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 Quote Link to comment 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" Quote Link to comment 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. 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.