count comment on each post

[tayyab]

hey guys
i want to count all comment on each post in my blog, my comment table contains 4 columns
id
name
comment
postid
and my query is

$qry=mysql_query("select count(*) as contentid from comment where id=41") or die(mysql_error()); $res=mysql_fetch_row($qry); echo "comments:::".$res['contentid']."";
the output is
comment:::0
but there are 4 comments behinde id 41

[Topcoder]

Let’s take a step back.

What happens when you run

[php]select count(*) as contentid from comment where id=41;[/php]

Directly on the database? Does it return the 4 Comments?

[tayyab]

i got it
thanks