Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Control panel that displays like Webassist Email block. - that joins a lot of tables (23 tables) based on an ID

View all replies to this thread

Control panel that displays like Webassist Email block. - that joins a lot of tables (23 tables) based on an ID

Thread began 4/29/2019 8:25 am by lr_leal239405 | Last modified 5/14/2019 11:33 am by lr_leal239405 | 1581 views | 12 replies

5/03/2019 9:40 amRay BorduinWebAssist

You probably just have to use AS statements to give each column a unique name like:

SELECT qr.quote_id_person, cs.quote_id_person as cs_quote_id_person, ir.quote_id_person AS ir_quote_id_person, ... FROM ...

That way you will have the unique column references to use when displaying the values on the page.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.