[SOLVED] Count something in MySQL Table?

[Jack Franklin]

Hi guys,

I'm building my own blog system to try and learn PHP. I have a comments table, where each comment has an ID, which relates to the ID of the article.

Example: Comments on Article No.1 have an ID of 1.

I want to count how many comments (IE, rows with ID=(ARTICLE ID)) so, if the article id=1, then I want to count the number of rows with the ID of 1.

How can I do this? Do you understand what I am saying?

Jack

[dab42pat]

I'm no expert and someone will probably give you a better answer but something like this might work

PHP: Select all

$sql =  mysql_query("SELECT count(id) FROM article WHERE id = "1"") or die(mysql_error()); 
$results = mysql_result($sql, "0"); 
print($results); 

if it doesnt work at least it may give you some ideas.

Pat

[alexgeek]

Typo in that code.. this should work.

PHP: Select all

$sql =  mysql_query("SELECT count(id) FROM comments WHERE id = '1'") or die(mysql_error()); 
$results = mysql_result($sql, "0"); 
print($results); 

I'd like to see your database structure.

[Jack Franklin]

From looking at the code that seems absolutely pefect for the job. If I change it to

PHP: Select all

WHERE id = '$articleid' 

Will that still work?

I'll try it and get back to you. Thanks for the response.

[Marc]

It will still work as long as you have a variable called $articleid.

[Jack Franklin]

Ok thanks. SOLVED

(For now anyway, might return if it fails :P)

Thanks, as usual, for the fantastic help

Jack