homer_3

Thanks, that's what I get for copy pasting code around. Didn't notice that.

I'm using sql with php and mysql_fetch_assoc is returning null even though mysql_num_rows returns 1. I've echoed the query statement I'm using and entered the output manually and sql does return a value. I'm not sure why the code is returning a null. Basically I have $rv = mysql_query("SELECT (blah) from my_table WHERE my_key = " . $value . ";", $mysql_link); echo "" . mysql_num_rows($rv); if(!$rv) { echo 'There was a problem with your order. '; die('Could not connect: ' . mysql_error($mysql_link)); }else { if ($row = mysql_fetch_assoc($sql)) { //code }else { echo 'There was a problem setting up your order. '; die('Missing fields: ' . mysql_error($mysql_link)); } } And the missing fields is printing out even though echo "" . mysql_num_rows($rv); shows 1.