[Resolved] Updates where record doesn't exist?

[mrbaseball34]

Why would this code NOT die with an error if the passed orderid
DOESN'T EXIST?

<?
// change these to your values
$dbhost = 'localhost';
$dbuser = 'root';
$dbpw   = '';
$dbname = 'usr_ww7541_1';

$orderid = $_GET["orderid"];

// connect and select the DB
mysql_connect($dbhost, $dbuser, $dbpw);
mysql_select_db($dbname);

$sql = "UPDATE `orders` SET `last_modified` = NULL , ";
$sql = $sql."`orders_status` = '3', ";
$sql = $sql."`orders_date_finished` = NULL WHERE `orders_id` = ".$orderid." LIMIT 1;";

$query = mysql_query($sql) or die(mysql_error());
echo "Done...";
?>

[Roger_Ramjet]

Because it is a valid sql query. Use mysql_affected_rows to find out if the query updated anything.
http://uk.php.net/function.mysql-affected-rows

Alternatively, you could be in an insert or update scenario, in which case use 'REPLACE'.
http://dev.mysql.com/doc/mysql/en/REPLACE.html

[mrbaseball34]

Thanks, that helped a lot.