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.

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