Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Joining tables

Joining tables

Thread began 11/09/2009 5:28 am by Heckie | Last modified 11/11/2009 1:22 am by Heckie | 2549 views | 4 replies

11/10/2009 2:02 amHeckie

Hi Jason,

Thanks for the reply, but it didn't work. At the moment I can get the 'ImageLocation' integer to appear with each image, but I want to display the 'LocationName' from Locations instead by joining (merging?) the two.

You will see on the test page above that it displays the INT OK.

I will attach the complete page, so that you can see the php code.

My Image table has the following relevant columns:
ImageID (INT)
ImageLocation (INT)

…and the Location table:
LocationID (INT)
LocationName (VARCHAR)

Attached Files

Location page.zip

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.