Display infomation from multiple tables

Hi Paul,

Are all of your members stored in separate tables or are you storing them in the User Accounts section?

Are these tables multi-record sections, or single page sections? How are these tables named?

Let me know and I can look into this issue further.

Hope this helps.

Hi Jason,

Thanks for getting back to me :)

Each member (now know as a dealer after changes made to the database today) is stored in a seperate table. For example:

Section (Table): dealer_1_contact
Fields: Address, Postcode, name, etc

Section (Table): dealer_2_contact
Fields: Address, Postcode, name, etc

It is a modified version of the contact template which is a Section Type: Single Record.

All sections (tables) are identical in structure.

Fingers crossed that makes sense :)

Paul

Hi Paul,

I see what your saying. Although it is possible to get the postcode from each of the tables, it would be quite a lot of work since you would have to include the name of each table you want to search in your MySql query.

The best thing to do would be to create 1 multi-record section (ex dealer_contact) and have each dealer as having 1 record in that section. This way you would only have to search 1 table to get everything you need. This would also mean you wouldn't have to recreate your same structure every time you added a new dealer.

Hope this helps.

Hello Jason,

Yeah normally I would do it that way but I have done it different this time as I have it setup so that depending on what subdomain they are it, it loads the relevant data. This is normally fine but for a dealer locator function I have setup in google maps, I now find myself needing them all togther in one table lol!

Would the solution you mention needa list of every table, be manualy updated for the search?

Also would it place much load on the SQL server?

Thanks

Paul

Hi Paul,

No problem. Let me know if you run into any issues.

thanks