mysql_num_rows returns 1 but mysql_fetch_assoc returns null?

[homer_3]

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.

[kicken]

 

	if ($row = mysql_fetch_assoc($sql))

 

You're using the wrong variable. $sql should be $rv.

[homer_3]

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