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! Quote Link to comment 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... Quote Link to comment 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 Quote Link to comment 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! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.