weblog comments

[jengle52]

i'm developing a small weblog system for my site. i have the weblog all set up, and pages that modify/add/delete posts.

but, i want to add a "comments" feature to my weblog, to allow people to comment on the posts.

i thought that i could have a table for each weblog post, which would hold the comments. but, i figure the database would get big VERY quickly.

how can i implement comments into my weblog?

jesse

[Zack]

have the weblog table's primary key postID or ID...

then make a table for comments whose primary key is comment ID or ID... then the second field in the comment table should be postID.. this way, when you call to look at the comments for a certain post, you can pull out all the comments with the same postID as the post itself.

[sfullman]

If the fields in the comments table and the weblog table are 95% the same, it makes sense to compile them into one table.

Just set up a second field for example Parent_ID (integer with default 0), which would contain the ID of the other entry if it was a COMMENT, otherwise it would be 0 and intererpreted as a WEBLOG item.

Of course youneed to do your indexes right, but you can also have threads started using this method because every post or comment is a "child of another post" if there's a non-zero value in Parent_ID. If Parent_ID is 0, it's a weblog or "parent" entry.

Just another thought on how to do it.

Sam