Hello,
perhaps a bit of a newbie question in regards to database programming, and I hope it hasn't been asked before, although I have done a search and nothing came up. If it has, my apologies. It's a bit specific, but here goes....
Each page has it's own comments and facility for creating comments. Each page is dynamically created from a database table. At the moment, I have it so that each page creates its own comments table within the database and names this table depending on the page's index number - ie 'comments_1' if the page's auto incremented index number is 1 - so the page can call up this table later.
My question is this: is this the correct way of doing this? Are there any downsides to doing it this way? Or, should all comments exist within the one table and have a column linking the comment entry to the page index. Although it works quite well the way I have done it, I'm starting to think it's a bit long-winded.
Any words of wisdom greatly appreciated!
