db scheme question...

[eluser]missionsix[/eluser]
You should use a single comments table, but your thinking about it wrong.

What you want here is a many to many relationship between tables.

So lets say you have articles, and want to add comments to them. you should have an intermediate table that stores the relationships between articles & comments.

Code:

+- Articles -+
--------------
-- id
-- ect..
--------------

+- Article_Comments -+
----------------------
--  Article_id
--  Comment_id
----------------------

+- Comments -+
--------------
-- ID    
-- comment
-- ect...
--------------

So you would create the relationship table for every thing that you want to add comments to. Then, you can add to your model, a way to retrieve comments using a joins based on comment_id from that table.



Hope that helps!