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