help with commenting script

abbey

hello everyone,

i'm working on a content posting system and i wanted to include a comment system to go along with it.

i was just wondering if anyone has any links to a few tutorials on doing something like this.

the script itself for posting, deleting and editing the news is all done and is running off MySQL. But, i was wondering whats the best way to include a comment system to the content system?

i'm a bit new to MySQL and Php but i have managed to get by little by little and learning by each application i build.

but any help would be greatly appreciated.

Thanks!

the_Igel

You can create a table named COMMENTS with fields id, article_id, text, date and whatever you need.

And article_id is to make connections with your article table and comment table.

So for each article (id=xxx), after printing it to the screen you put smth like

$r = mysql_query("select * from comments where article_id = xxx");

while (row = mysql_fetch_array($r))
{
// print comment
}

And in the "post new comment" form you put a hidden field called article_id with value xxx.

Hope this helps a bit.

abbey

ok, but how do i make it so that when i post the news and have that 'post a comment link', how do i link the two tables together so that once they their comment it post it into the comments table and is linked to that article?

thats the only thing i cant understand right now.

the_Igel

look.

Once you post a news-record, it gets an id in NEWS table, right?

Then you use this id as a key for posting comments:

<A href="comment.php?id=123">post a comment!</a>
(it is to be a line in show_news.php?id=123)

and here's a snippet of comment.php:

$id = $_POST['id'] + 0; // to be sure it's a number.

?>
<FORM action="post_comm.php">
<INPUT type="hidden" name="news_id" value="<?echo $id;>?">
<TEXTAREA name="text">write here</TEXTAREA>

and in post_comm.php you put

mysql_query("insert into comments (news_id, text, date) values($news_id, '$text', now())");

If it doesn't help, I apologize, because i obviously don't understand what is your problem.

cindango

hmm, this is perfect. Thanks Igel.