[SOLVED] Help with count query

[mediabob]

Hi, I am trying to count specific rows in the db and I can't get it right, here is what I am using:

 

$countShows = mysql_query("SELECT count(*) FROM rating WHERE itemid = '$file_id' AND ruserid = '$name' AND rcat = '$catname' ");
$count = mysql_result($countShows, 0, 0);

 

The variables and connection details are handled earlier in the script, I know the connection is OK because there is another query that works and I checked the variables and they are returning the correct value, but I get this error when I view the page:

 

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/usr/public_html/ddd/ddd/page.php on line 105

 

This actually worked, but then stopped working for no reason, nothing was changed.

 

Thanks

[mmarif4u]

Try this:

 

$countShows = mysql_query("SELECT count(*) FROM rating WHERE itemid = '$file_id' AND ruserid = '$name' AND rcat = '$catname' ");
$num_rows = mysql_num_rows($countShows);
echo $num_rows;

[mediabob]

get the same error, says mysql_num_rows is not a valid result resource

[mmarif4u]

$countShows = mysql_query("SELECT * FROM rating WHERE itemid = '$file_id' AND ruserid = '$name' AND rcat = '$catname' ");
$num_rows = mysql_num_rows($countShows);
echo $num_rows;

[mediabob]

??? still same error :-\

[mmarif4u]

can u show us the full code.

[pdkv2]

Do one thing try to print the query, i guess the query must be having the problem.

[mediabob]

OK when I tried to print the query it told me there was no database selected, so I played with it and finally got this to work

 

$query_countShows = "SELECT * FROM rating WHERE itemid = '$file_id' AND ruserid = '$name' AND rcat = '$catname'";
$countShows = mysql_query($query_countShows, $dload) or die(mysql_error());
$num_rows = mysql_num_rows($countShows);

 

Thanks for your help guys!