query won't work

[kristin Lai]

Okay, I can't for the life of me figure out what's wrong with this query but I keep getting the "not a valid result resource" error message. I've checked that the db fieldname is spelled correctly and there is a value stored in the $image variable so any suggestions would really help. Here's the query:

[code=php:0]
$queryImg = "SELECT * FROM images WHERE imgID=$image";
$resultImg = mysql_query($queryImg)
or die ("could not retrieve image");
$rowImg = mysql_fetch_array($queryImg,MYSQL_ASSOC);
extract ($rowImg);
[/code]

[shocker-z]

You need
[code=php:0]
$queryImg = "SELECT * FROM images WHERE imgID='$image'";
$resultImg = mysql_query($queryImg)
or die ("could not retrieve image");
$rowImg = mysql_fetch_array($queryImg,MYSQL_ASSOC);
extract ($rowImg);
[/code]

as '$image' show's it as a string but without the '' it looks for it as a field :)