Jump to content

mysql_num_rows returns 1 but mysql_fetch_assoc returns null?


homer_3

Recommended Posts

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.

Archived

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

×
×
  • Create New...

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.