Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result reso

[louis_coetzee]

Hi, I get the error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\eliteacc\lib\database.php on line 45

# Finds one product by id.
# Returns Array.
function find_listing($id)
{
	db_connect();
	$query = sprintf("SELECT * FROM listing where listing.id = '%s'", mysql_real_escape_string($id));
	$result = mysql_query($query);
	$row = mysql_fetch_array($result);
	return $row;
}

[Zyx]

You have an error in the query and mysql_query() returned false instead of result resource. Use MySQL error reporting functions to get to know more.

[louis_coetzee]

You have an error in the query and mysql_query() returned false instead of result resource. Use MySQL error reporting functions to get to know more.

 

Thanks, stupid mistake in query. Solved.