musnoure Posted January 16, 2012 Share Posted January 16, 2012 Hello, I am not new to PHP/MySQL but I do need some advice with the following. The website will have Categories (Main Category) and Sub-Categories. For instance, Authors --> List of Authors --> Authors' Book Lists --> Book Details. So I will need 2 to three sub-categories. I will need to create relational Database, but what is the best Database structure to start with? I know this is a very broad question but any ideas so I can get started would be very much appreciated! - Noureddine Link to comment https://forums.phpfreaks.com/topic/255125-i-need-some-help-with-building-mysql-driven-website-with-php/ Share on other sites More sharing options...
Muddy_Funster Posted January 16, 2012 Share Posted January 16, 2012 the broad answer to your broad question is "A normalised one" Link to comment https://forums.phpfreaks.com/topic/255125-i-need-some-help-with-building-mysql-driven-website-with-php/#findComment-1308106 Share on other sites More sharing options...
thehippy Posted January 18, 2012 Share Posted January 18, 2012 Quick and dirty answer: You're wishing to store hierarchical data, google can point to many tutorials on the subject. Link to comment https://forums.phpfreaks.com/topic/255125-i-need-some-help-with-building-mysql-driven-website-with-php/#findComment-1308816 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.