melting_dog Posted December 21, 2011 Share Posted December 21, 2011 Hi all, I am working on a site for a client so there is an existing database. I have a simple query: $sql3 = "SELECT * FROM product_finish WHERE product_id = $prodid"; if($result3 = mysql_query($sql3)){ if(mysql_num_rows($result3)) { while($row = mysql_fetch_array($result3)){ echo $row['finish_id']; } } } Which is all syntactically correct, BUT it returns noting....even if run it in phpMyAdmin and hard code it so the $prodid is, say, 4 instead. I can see the data when I browse the data, just the query will not fetch it. Can anyone give me some advice? Thanks heaps again! Link to comment https://forums.phpfreaks.com/topic/253596-strange-query-returns-no-results/ Share on other sites More sharing options...
melting_dog Posted December 21, 2011 Author Share Posted December 21, 2011 I should also add that all other tables in the database respond fine to queries - just not this one... Link to comment https://forums.phpfreaks.com/topic/253596-strange-query-returns-no-results/#findComment-1300027 Share on other sites More sharing options...
dzelenika Posted December 21, 2011 Share Posted December 21, 2011 try with: $sql3 = "SELECT * FROM product_finish WHERE product_id = $prodid"; if($result3 = mysql_query($sql3)){ if(mysql_num_rows($result3)) { while($row = mysql_fetch_array($result3)){ echo "finishID:" . $row['finish_id']; } } else { echo "no rows returned";} } else { echo "query error";} to see where problem happens Link to comment https://forums.phpfreaks.com/topic/253596-strange-query-returns-no-results/#findComment-1300033 Share on other sites More sharing options...
melting_dog Posted December 21, 2011 Author Share Posted December 21, 2011 Thanks dzelenika! Thats done the trick! Link to comment https://forums.phpfreaks.com/topic/253596-strange-query-returns-no-results/#findComment-1300037 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.