Jump to content


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


MySQL / PHP Query Failure

Recommended Posts

Okay, I have a query that works (echoed, copied, pasted, and tested). Returns 6 rows.

Run the same query in PHP using mysql_query or die combo - works great, no errors, HOWEVER, mysql_num_rows and mysql_fetch_row return0 results.


THIS IS NOT AN ERROR - it returns 0 rows on a succesful query.


Anybody else, suggestions, ideas?


This is WIERD.


//query for images
$strQuery = "select images_filename_thumbnail, imageEv_id, imageEv_event_name, i.id from     carnival_images i, carnival_images_events ie where i.id = ie.imageEv_image_id and imageEv_event_name = '$eventName'";
$resImage = $db->query($strQuery);
return $db->count_rows($resImage); // returns 0 rows, in ppMyAdmin returns 6 rows

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.