sql error... but no error

drag0n

		$profilePicSql = mysql_query("SELECT * FROM `accounts` WHERE `id` = 1") or die("mysql_error()");
		$profilePicRows = mysql_fetch_array("$profilePicSql") or die("error 2");

What is wrong with the above code? The code always dies at the mysql_fetch_array(). The query is fine... no errors. I do not see what is wrong with the code. It just simply dies or return no value if I do not put the die clause.
Its probably a stupid mistake... lol. Thanks in advanced!

cgraz

add mysql_error() after mysql_fetch_array() so if there is an error you'll know what it is.

Also, drop the quotes around your parameter when you call mysql_fetch_array()

drag0n

oops sorry. the quotes arent in the real code... i retyped it onto here... got sloopy. my bad.
i tried to add mysql_error() after the fetch_array... still nothing shows up.

NogDog

I think mysql_fetch_array() will return false if no rows were returned. To aid debugging, I would do something like:

$sql = "SELECT * FROM `accounts` WHERE `id` = 1";
$profilePicSql = mysql_query($sql) or die("mysql_error()<br />query: $sql");
if(mysql_num_rows($profilePicSql) == 0)
{
   die("No rows returned. Query: $sql");
}
$profilePicRows = mysql_fetch_array("$profilePicSql");

bradgrafelman

Minor correction to NogDog's code:

$sql = "SELECT * FROM `accounts` WHERE `id` = 1"; 
$profilePicSql = mysql_query($sql) or die(mysql_error() . "<br />query: $sql"); 
if(mysql_num_rows($profilePicSql) == 0) 
{ 
   die("No rows returned. Query: $sql"); 
} 
$profilePicRows = mysql_fetch_array($profilePicSql);

faifas

Was about to say that mysql_error() shouldn't be quoted :x