need another pair of eyes

[RyanSF07]

Hi Guys,

 

I'm getting this error:

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

 

on this code:
$result = mysql_query("SELECT * FROM $table WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
?>

 

do I have apostrophe's in the wrong place?

 

thanks for your help.

 

Ryan

[gevo12321]

try this

$result = mysql_query("SELECT * FROM $table WHERE id=$id");
$myrow = mysql_fetch_array($result);

[teng84]

hmmm

try this

"SELECT * FROM ".$table." WHERE id=".$id.""

the code you seems ok but try that one

[AndyB]

Better yet, add some error trapping so you will know just why the query is failing:

 

$query = "SELECT * FROM $table WHERE id = '$id'";
$result = mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query);
$myrow = mysql_fetch_array($result);