[SOLVED] Count Records

[papaface]

Hello,

How can I count how many records are in a table that match a news_id?

I have this at the moment, but it doesn't seem to work.

					<?php
				$_getcomments = mysql_query("select count(comment_id) from comments where news_id='{$news_id}'");
				list($__num) = mysql_fetch_array($_getcomments);
				echo $__num;
				?> Comments</div>

I get:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /***/index.php on line 48

Comments

[tauchai83]

try this:

 

 

</php

$_getcomments = mysql_query("SELECT count(comment_id) AS cnt FROM comments where news_id='$news_id' ");

echo $cnt;



?>

 

if it is not work, add GROUP BY comment_id

[papaface]

That works in a way.

I don't get an error now. But I dont get the number that it should be.

It should say there is 1 record in the database with news_id, but it doesnt print anything.

[tauchai83]

Alternatively,

 

<?php

$_getcomments = mysql_query("SELECT count(comment_id) AS cnt FROM comments where news_id='$news_id' ");
$num=count(mysql_num_rows($_getcomments));

echo $num;


?>

 

now try this. haha. keep on trying.

[papaface]

Now I get:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /***/index.php on line 52

0Comments

[tauchai83]

check your column name and also ehco out the variable. see what you get? $news_id value is passed?

[tauchai83]

you should try this:

<?php

$sql="SELECT * FROM comments where news_id='$news_id' ";
$result=mysql_query($sql);
$count=mysql_num_rows($result);

echo $count;
?>

it should work!

[papaface]

lol I just found out the problem.

I have multiple databases running on this script and I forgot to reference the connection lol.

Sorry about that, and thanks for your help.

[tauchai83]

welcome.