Warning: mysql_num_rows():

[justoneguy]

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());

[chigley]

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.

[taith]

agreed... thats tripple posting there! calm down... bump your other post if it gets lost and unsolved...