Not handling the null field

[Philosophaie]

I have purposefully made one of my options the null or "" option. When the null option is executed there is an if statement to handle it:

$id  = mysql_fetch_array($result, MYSQL_ASSOC);
if ($id == ""){
    	return header("http://www.site.com/index.htm");
}

The rest of the sql part works. I just keep getting an error:

mysql_fetch_array() expects parameter 1 to be resource, boolean ...

Why is it not handling the null field?

[WolfShade]

The database is returning null, not a value or recordset. If you can, set it so that if the return value is null then a default value is returned.

[Philosophaie]

I can not find anything wrong with the database or the surrounding code. It is just the same as what I usually use:

mysql_select_db('database1');

[ZABI]

try $result=mysql_query("your query here") or die(mysql_error());

to find out if your query is running properly...