How to show images from a relational database table
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 ()"