Discussion blog Database Structure

[ak1dnar]

Hi,
I need to develop a Discussion blog that enables web site user to start new topics and post their comments on it.

currently there is a design structure template for this my backend system should work in order to this.I need to know about the Database table structure for this.Still i cant think about a database design for this.
any tutorial, ideas, links all are accepted.please take a look at for This Template .
and wish to here from you.

[Motoma]

Hi,
I need to develop a Discussion blog that enables web site user to start new topics and post their comments on it.

currently there is a design structure template for this my backend system should work in order to this.I need to know about the Database table structure for this.Still i cant think about a database design for this.
any tutorial, ideas, links all are accepted.please take a look at for This Template .
and wish to here from you.

Create a data structure where every comment has a comment id, a parent id, a subject, a body, a user id, and a date.
Your logic will be if the parent id is null or zero, it is a thread, and if the parent id is the same as another item's comment id, then it is a reply.

[ak1dnar]

Thank you very much motoma. I take my entire day time to make it. i made it as far as i could. this is the latest. i am working on to fix the remaining bugs.thanks for helping on the db structure :). for the remaining bugs i have to go for Ajax forum.