Jump to content

Archived

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

kristin Lai

query won't work

Recommended Posts

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]

Share this post


Link to post
Share on other sites
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 :)

Share this post


Link to post
Share on other sites

×

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.