Ok, its pretty easy. When I designed my table, I also created a column for tutorial id. Then, I do a query like this:


Code:

My comments table is like this:

Code:

Sorry, the person above is me..

wakk...
I don't mean to post 3 times..and I don't know how to delete them..sorry...

well, you get the article id with $_GET['id'];

like if your url was like this:

site.com/articl es/view.php?id= 5

$_GET['id'] would = 5. So you can change that $id to $_GET['id'] in your query, should work

actually I get that one right, but I could not show total comments per article_id, for example article_id 1 has 9 comments, and there is no article_id 2, but it also shows up 9 comments..pleas e see my MySQL table:

Code:

well; what if when you do have more than 1 article? you'll use a while loop to display each article and respective comments. so...

do something like:


Code:

<?
while($total_co mments = mysql_num_rows( $q2)) {
echo("(&l t;a href='../comme nt.php?id=&quo t;.$id." ', ".$total_ comments." ; ,'</a>' , ' Comments.')&q uot;
}
?>

LoL..it's flooding...

News & Updates

Article: Testing
By: Admin on the 22-09-2003 @ 18:25:18

Testing Testing Testing Full Description
--------------- --------------- --------------- --------------- --------------- -----
(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9)

..........
Did I do something wrong?


Code:

do this...


Code:

It's not working too.. ..please help..

Here is the result:
=============== =============== ===
Article: Testing
By: Admin on the 22-09-2003 @ 18:25:18

Testing Testing Testing Full Description
--------------- --------------- --------------- --------------- --------------- -----
(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.

--------------- --------------- --------------- --------------- --------------- -----
Article: Testing 2
By: on the 31-12-1969 @ 18:00:12

Testing Again 2
--------------- --------------- --------------- --------------- --------------- -----
(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.(9) Comments.

Hrm.. well, im not sure. I will have to look into this more in detail when im off work today. Until then, maybe Misterhaan will catch this thread and offer some help

LoL..
please help me when you are back...

drop the while from bs0d's last post with code -- it's looping over all the comments and writing out the total number of comments each time.

Thank you for the post, misterhaan..but the problem is back again..I could not count the number of comments per article_id ..see here:
------------- News & Updates

Article: Testing
By: Admin on the 22-09-2003 @ 18:25:18

Testing Testing Testing Full Description
--------------- --------------- --------------- --------------- --------------- -----
(9) Comments.

--------------- --------------- --------------- --------------- --------------- -----
Article: Testing 2
By: on the 31-12-1969 @ 18:00:12

Testing Again 2
--------------- --------------- --------------- --------------- --------------- -----
(9) Comments.

--------------< br />
There is no comment for Article 2 but it still counts as 9 comments..

follow along this code with your proper table names and column names

Code:

<?
$q_articles =mysql_query(& quot;SELECT * FROM `articles`&quo t;
if(!$q_articles ) die(mysql_error ());

while($show = mysql_fetch_obj ect($q_articles )) {

echo("art icle name: ".$show-& gt;name." id: ".$show-& gt;id."&l t;BR>"< img src=http://www. allsyntax.com/f orums/images/sm ilies/wink.gif border=0>;

//now query comments for this article
$q2 = mysql_query(&q uot;SELECT * FROM `comments` WHERE `article_id` = '".$show ->id." '";
$how_many = mysql_num_rows( $q2);
if($how_many >= 0) {
echo(" 0 comments"< img src=http://www. allsyntax.com/f orums/images/sm ilies/wink.gif border=0>;
} else {
echo("thi s article has ".$how_ma ny." comments." ; <BR> ";
}//end else
} //end while
?>

bs0d....thank you...it's working...
but I must change
if($how_many >= 0) {

to

if($how_many == 0) {

Do you think is that okay?


Here it is how it shows up:
article name: Testing id: 1this article has 9 comments.
article name: Testing 2 id: 2this article has 0 comments.

eh, that was suppose to be less than or equal to, my bad. you're all fixed up!

thank you..