Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resour

[justoneguy]

please help this error comes up i have no idea ???

 

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /right.php on line 105

 

 

<?
if ($crew =="1") {
$bb = mysql_query("SELECT * FROM replys WHERE idto='$viewtopic' forum='$forum' AND crew='$fetch->crew'");
}else{
$bb = mysql_query("SELECT * FROM replys WHERE idto='$viewtopic' forum='$forum'");
}
while($success1 = mysql_fetch_row($bb)){ [color=red]line105[/color]
     $username11 = $success1[1];
 $text = $success1[2];
 $made1 = $success1[5];
 } 
 ?>

[chigley]

You query is failing.

 

<?php

if ($crew =="1") {
$bb = mysql_query("SELECT * FROM replys WHERE idto='$viewtopic' forum='$forum' AND crew='$fetch->crew'") or die(mysql_error());
}else{
$bb = mysql_query("SELECT * FROM replys WHERE idto='$viewtopic' forum='$forum'") or die(mysql_error());
}
while($success1 = mysql_fetch_row($bb)){ [color=red]line105[/color]
     $username11 = $success1[1];
 $text = $success1[2];
 $made1 = $success1[5];
 }

?>

[justoneguy]

thanks for your help but now it shows this

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'forum=''' at line 1

 

[chigley]

<?php

if ($crew =="1") {
$bb = mysql_query("SELECT * FROM replys WHERE idto='$viewtopic' && forum='$forum' AND crew='$fetch->crew'") or die(mysql_error());
}else{
$bb = mysql_query("SELECT * FROM replys WHERE idto='$viewtopic' && forum='$forum'") or die(mysql_error());
}
while($success1 = mysql_fetch_row($bb)){ [color=red]line105[/color]
     $username11 = $success1[1];
 $text = $success1[2];
 $made1 = $success1[5];
 }

?>

[justoneguy]

thanks