Grab 1 image from 2nd table per listing
Posted: Mon Sep 26, 2011 3:07 am
Hi,
I have 2 tables.. one for listings and the other for photos.. I havnt been able to display one image per listing trying a query within a loop and also a table join.. Both options are briging back the same photo for all listings, even listings with no photos..
the link between the tables is "listingid"
How can I acheive this?
Thanks
I have 2 tables.. one for listings and the other for photos.. I havnt been able to display one image per listing trying a query within a loop and also a table join.. Both options are briging back the same photo for all listings, even listings with no photos..
the link between the tables is "listingid"
How can I acheive this?
Thanks