Jump to content

Warning: mysql_num_rows():


justoneguy

Recommended Posts

please help am getting this Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in right.php on line 127

 

 

the line is the $num=mysql

 

 


if ($crew == "1"){
$query=mysql_fetch_object(mysql_query("SELECT * FROM replys WHERE idto = '$viewtopic' AND forum='$forum' AND crew='$fetch->crew' ORDER by `id` DESC LIMIT $forum_look, $forum_count"));
}else{
$query=mysql_fetch_object(mysql_query("SELECT * FROM replys WHERE idto = '$viewtopic' AND forum='$forum' ORDER by `id` DESC LIMIT $forum_look, $forum_count"));
}



$num=mysql_num_rows($query)or die(mysql_error());

Link to comment
https://forums.phpfreaks.com/topic/53981-warning-mysql_num_rows/
Share on other sites

Allow me to quote from your other two topics:

 

Read my post in your other topic, no need for two.

 

Sounds like your queries are failing:

 

<?php

if ($crew == "1"){
$query=mysql_fetch_object(mysql_query("SELECT * FROM replys WHERE idto = '$viewtopic' AND forum='$forum' AND crew='{$fetch->crew}' ORDER by `id` DESC LIMIT $forum_look, $forum_count")) or die(mysql_error());
}else{
$query=mysql_fetch_object(mysql_query("SELECT * FROM replys WHERE idto = '$viewtopic' AND forum='$forum' ORDER by `id` DESC LIMIT $forum_look, $forum_count")) or die(mysql_error());
}

?>

 

I neatened it up a little and added debugging, it will now display query errors to help you.

 

Seriously, one thread is enough.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.