The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

SQL and Pictures database design ! Need help

Hi all,
No where better to seek advice that from a collective mind. I am setting up a site for the purpose of having people post any residence they wish to rent. Although I do have an idea of how I wish to set up the data I do wish to seek more advice incase I missed something.

The data layout would be as follows:
1) Alpha-numeric data will be placed within mySQL so its easier to perform searchs on certain strings, mostly would be by locale and price.

2) The problem I have is the pictures if someone wishes to submit them for his residence or building. Shall I have the data related to the pictures in the database and the pictures in another folder (which is what I am currently planning) ? Any other better ideas out there ?

You're planning to do it right. As I've said in another post, IMHO file systems are for storing files and databases are for storing data, so let both do what they're best at ... put your images in a folder and write the relative path to that image into the database. That's how I did it for a similar problem and it works a treat. Much better than using a file field.