Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

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

View all replies to this thread

Joining tables

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

11/10/2009 10:03 amJason ByrnesWebAssist

Change the Select .... From prtion of the rsImages recordset:

SELECT *, DATE_FORMAT(ImageDate, '%%D %%M %%Y') as ImageDate FROM Image

to:

SELECT Image.*,Location.LocationName , DATE_FORMAT(Image.ImageDate, '%%D %%M %%Y') as ImageDate 
FROM Image
INNER JOIN Location
ON Image.ImageLocation = Location.LocationID

The you can use the LocationName from the rsImages recordset to return the correct location name.

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.