Thanks again for your insight Mike.

---

if a property has no image then it will never show up
- The properties are showing up and I have an image signifying there isn't an image associated with the listing in the retrieval.

at the moment a malicious user could attack your data through your PHP form as you don't check what's in any field before adding the contents of any variable to your SQL - you need to read up on PHP and SQL injection attacks.
- I'll read up on this.

there's no way of knowing which image to use when showing a property, a user could be looking for a $10m beach side property but could just be shown an image of an toilet beside the pool rather than the main picture of the house as there's no way for the program to tell the difference.
- You're right and that's is another issue I'm trying to sort out.

---

I would hire someone, but then it would defeat the whole purpose of me learning how to do this myself. Bugs and all, it's something I enjoy.

Thanks for your feedback on this Mike.

As for optimizing the speed of the query did you recommend anything you haven't already wrote about?