mysql_num_rows error

Trid3nt

I'm getting this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/w0rd/public_html/trid3nt/BEM/my_classroom/upload_image.php on line 23

When I try to perform this code:

$query = "SELECT Gallery, Image FROM " . $username . "_galleries WHERE (Image=\"" . $image . "\" AND Gallery=\"" . $gallery . "\")";
	$result = mysql_query($query);
	$image_exist = mysql_num_rows($result);

It happens whenver I've used mysql_num_rows($result). I'm not sure why because I'm reading that this is how to do it in my PHP book. Any ideas??

keith73

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/w0rd/public_html/trid3nt/BEM/my_classroom/upload_image.php on line 23

This error indicates that the result is not valid because there is probably an error with your query.

Output the query to the browser and see that it is using correct syntax and that the table and fields you are trying to access actually exist.

this is probably what it looks like:

SELECT Gallery, Image FROM johndoe_galleries WHERE (Image="myimage.gif" AND Gallery="mygallery")

try using single quotes within the query. I don't know if that is the problem, but it's worth a try.

you are using mysql_num_rows correctly.

what book are you looking at?

Keith

Trid3nt

Wow that did the trick! Instead of using a single quote around the WHERE arguments in my query, I used a double quote. That worked perfectly. Thanks for the help!!

I'm using PHP4 Bible and the Visual Quickstart Guide "PHP for the World Wide Web". Thanks again!