List Options from database - multiple tables

You could do this with "Get options from Msql Query" but it would be some complex MySQL.

Depending on what you're trying to do you'd have to use a mysql UNION (http://dev.mysql.com/doc/refman/5.0/en/union.html). This lets you combine multiple SELECT statements.

It might be simpler to re-arrange your sections and data. What result are you looking for (what are you trying to combine, etc)?

ok... well i have 3 sections

Summer Academy Locations, Futsal Academy Locations, Goalkeeper Academy Locations

they all have the same fields when creating a new location within one of these academys.

I split them up because I needed a different viewer url for each Academy.

Ok, well let me know how you want to proceed. It might be easier to combine them again then to figure out the SQL union.

Have many records been entered yet?

You can combine them into "Academies" and have a list field such as "type" for (Summer, Futsal, GoalKeeper). You can also use multiple viewers even though they're from the same section. You just add "type = 'Summer'" or something like that into the where on the list page.

Let me know what works best and what you want to try first.

OK... yea i was thinking about doing a locations tab and then making a field to chose the Academy.

But for instance if you were to click on a location in Futsal Academy, the detail page of that location would have a different header than the detail page of Summer Academy.

not sure i understand the where=Summer thing and if that will work..

goto apexfinal.highviews.co.cc

you will see 3 picture tabs at the top for each Academy...

When you click on there it takes you to that academy page.. from there you can select a location in that Academy..

just take a quick look and let me know if what you are saying will work.

I only have testing records posted as of now so it wouldnt be a big deal to combine all into a locations tab...

instead of having 3 locations tab in the CMS

Hi there.

I took a look at your site and I think I see what you are aiming for. When you click to one of your academies, there is a part on each of those pages that is labeled "Session Schedule". This is where a list of locations needs to load right?

If this is the case, Dave's suggestion would work. You would create a new section called "Locations" and in that section you would have a drop down menu called "type" with each academy as an option.

From there, one each of your three pages, you would just need to add one extra line to the viewer code for each of your academy pages so that it loads the proper list of locations.

Let me know if that all still makes sense and we can go over the code in some more detail if you like