soos Posted January 31, 2012 Share Posted January 31, 2012 I'm creating a re classified ad site and I've hit a brick wall. I'm trying to create a 'listing' which will contain info and pictures of the property that's for sale, but I'm unsure on how to do it. Would I have to create different db tables to have the albums, images and listing together? Or would can I just do it all in one table? I appreciate your help. Quote Link to comment Share on other sites More sharing options...
Psycho Posted February 1, 2012 Share Posted February 1, 2012 You will want separate tables for each record "type". For example, you would have a listings table that has one record for each listing. But, each property may have no images or many. So, you would have a separate images table with one record for each image with a field to identify which listing each image belongs to. There are a LOT of different considerations on designing a database - way more to even start going over here. Go google for some beginner articles on database normalization. Quote Link to comment Share on other sites More sharing options...
soos Posted February 1, 2012 Author Share Posted February 1, 2012 I researched a few database normalization examples and explanations and got the grasp of it. Thanks, Psycho. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.