'or die' not working. Please help

[Anon]

<?

//this connection works fine
require ("makodata_connect1.php");

//the area code doesn't exist in my database
$result=mysql_query
("SELECT * FROM user_data
WHERE phone_area='444'")

//the query should die here, but doesn't!
or die ("no record");
?>

I've also tried an if/else statement but get similarly strange results.

if(!$result)
{die ("no record found");
}

but the same thing happens! I goes right past it as if it weren't even there.

Does anyone have any suggestions??

[jjoske]

try this

if(mysql_num_rows($results)==0)) {
die("No Record!");
}

[[deleted]]

'or die()' only happens when whatever is in from of it fails.

In your case, the query does NOT fail, it just returns no records.
Thus the 'or die' is not executed.

PS, try not to use the 'or die' too much. You'd be better off using IF statements so you can cleanly stop your program.
when you use 'or die', you are relying on PHP to close your database connections etc, and often you don't really want to stop the program just because you couldn't find a record.