mrknowledge Posted April 12, 2007 Share Posted April 12, 2007 So say i have 100 pages all with stories on them, and people can comment on each story... is it best to have one table and just sort by ID's... or to create a table for each single page? thanks Quote Link to comment https://forums.phpfreaks.com/topic/46720-categorizing-or-no/ Share on other sites More sharing options...
beaux1 Posted April 12, 2007 Share Posted April 12, 2007 Well a table for each story would be rather unnecessary. I mean, if you have 100 stories then 100 SQL tables it isn't going to be efficient. If I was you I'd have 1 table for all 100 stories, and then sort them on the page you're displaying them on by using a ORDER statement such as: ORDER BY title; 'Title' is the title of the story, so your stories will be listed alphabetically on the page. Quote Link to comment https://forums.phpfreaks.com/topic/46720-categorizing-or-no/#findComment-227632 Share on other sites More sharing options...
fenway Posted April 12, 2007 Share Posted April 12, 2007 Sounds like you'll need a comments table with a story_uid. Quote Link to comment https://forums.phpfreaks.com/topic/46720-categorizing-or-no/#findComment-227649 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.