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. Link to comment https://forums.phpfreaks.com/topic/256152-question/ 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. Link to comment https://forums.phpfreaks.com/topic/256152-question/#findComment-1313158 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. Link to comment https://forums.phpfreaks.com/topic/256152-question/#findComment-1313217 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.