Display infomation from multiple tables

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 Jason,

Ignore this thread now :)

I have now learnt how to merge arrays (for another part of the site) and understand what is required for the postcode search.

I am looking at alternatives :)

Thanks for your help!

Paul

Hi Paul,

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

thanks