[SOLVED] Count something in MySQL Table?

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

__________________
Jack Franklin - Webforumz Moderator
(x)HTML | CSS | PHP | MySQL | JQuery (Javascript)
Contact: My Blog | Twitter | Delicious
Want Lessons? PM me.
If you think I've helped, please press the 'Thanks' Button.

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

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.

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.

__________________
Jack Franklin - Webforumz Moderator
(x)HTML | CSS | PHP | MySQL | JQuery (Javascript)
Contact: My Blog | Twitter | Delicious
Want Lessons? PM me.
If you think I've helped, please press the 'Thanks' Button.

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

__________________
Marc
Staff Manager - Webforumz.com

Want to be a moderator? PM me.

Ok thanks. SOLVED

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

Thanks, as usual, for the fantastic help

Jack

__________________
Jack Franklin - Webforumz Moderator
(x)HTML | CSS | PHP | MySQL | JQuery (Javascript)
Contact: My Blog | Twitter | Delicious
Want Lessons? PM me.
If you think I've helped, please press the 'Thanks' Button.