[SOLVED] Mysql count not returning anything

[mikwit]

This script originally worked, but now is returning nothing for me.  I could always not use the count on the mysql side and use the mysql count results command, but that's not as efficient (I assume) and I'm really trying to build my site to scale well.

the php code involved is

$number=$_GET['a'];
$sql = 'SELECT COUNT(*) AS CNT FROM comments WHERE replyto='.$number; 
$comnum = mysql_query($sql) or die('query broke:<br />');
echo $comnum['CNT'];

This is returning nothing even though there are rows where replyto=$number... I'm almost positive it used to work, but I must have messed up something...

Thanks so much, I would've given up on computers a long time ago if it wasn't for you guy's help.

[Maknis]

do a print_r($comnum);

whats it say

 

This script originally worked, but now is returning nothing for me.  I could always not use the count on the mysql side and use the mysql count results command, but that's not as efficient (I assume) and I'm really trying to build my site to scale well.

the php code involved is

$number=$_GET['a'];
$sql = 'SELECT COUNT(*) AS CNT FROM comments WHERE replyto='.$number; 
$comnum = mysql_query($sql) or die('query broke:<br />');
echo $comnum['CNT'];

This is returning nothing even though there are rows where replyto=$number... I'm almost positive it used to work, but I must have messed up something...

Thanks so much, I would've given up on computers a long time ago if it wasn't for you guy's help.

[abazoskib]

you need to do this:

 

$number=$_GET['a'];
$sql = 'SELECT COUNT(*) AS CNT FROM comments WHERE replyto='.$number; 
$comnum = mysql_query($sql) or die('query broke:<br />');
$row=mysql_fetch_assoc($comnum);
echo $row['CNT'];

[mikwit]

you need to do this:

That did the trick. Thanks a lot