As part of a property site I had all info held in one table called 'properties'. However I have just changed the make up.
Before there were 10 columns in the properties table: image1, image2 etc...I thought having a specific table for images was the way to go so the image filenames are now in a separate relational table called 'images'
I'm not sure though how to display the images. Before, for the thumbnail results page I would use...
SELECT propertyID, pricePrefix, additionalimage1, country_code, image1, name, FORMAT(prices,2) as prices, `currency` FROM properties WHERE cityCode = '456' ORDER by RAND ()"
How do I make this query display an image/filename from the images table if the 'propertyid' value matches the 'PropertyID' from the 'properties' table