Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › I want to join two tables on my details page so I can include member contact info on my details pages.

I want to join two tables on my details page so I can include member contact info on my details pages.

Thread began 10/25/2022 12:33 pm by jo271221 | Last modified 10/31/2022 9:07 am by Ray Borduin | 296 views | 3 replies |

10/25/2022 12:33 pm | #1 jo271221

I want to join two tables on my details page so I can include member contact info on my details pages.

I am attaching my page and including info in private message.

Attached Files

event-details2.php

10/25/2022 2:30 pm | #2 Ray BorduinWebAssist

You just have to add a join to your SQL like:

INNER JOIN tbl_directorylistings ON tbl_directorylistings.id = tbl_posts.customerid

Did this help? Tips are appreciated...

10/27/2022 7:04 pm | #3 jo271221

I have INNER JOIN in my example. If that looks correct then I believe I need help with the WHERE so I obtain the id /customerid from the URL -
SQL pasted again in PM

10/31/2022 9:07 am | #4 Ray BorduinWebAssist

It looks correct to me. Give me a call later this afternoon and I'll help you in a screen sharing session. I don't think it will take more than a few minutes for you to describe the issue and I can help you fix it.

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.