Showing # of comments

[SDP2006]

I am making a comments system for my blog and I want to show how many entries total there are in the comments db table. How might I do this? I was thinking about SELECT MAX(id) FROM comments, but if you deleted one, it would show the highest number, not the total number of comments.

Thanks to all,

Stevie

[Nightfire]

mysql_num_rows() will show the number of comments

[raf]

If you don't want to display the comments, then you can use

select count(*) as thecount from ....
and then you can use $row['thecount'] to get the count.

If you also display the comments, then use mysql_num_rows() like Nightfire suggested.

[SDP2006]

Originally posted by Nightfire
mysql_num_rows() will show the number of comments

I knew that. I'm stupid. Thanks, it works.

[super kobs]

Another day, another noob saved :-D. jk

[SDP2006]

Noob? No.

Expert? No.

So, go on.