mysql_query($query) or die(mysql_error);
will give an error and stop the script if there is an issue, this also can work for the mysql_select_db
bastien
From: "Ron Piggott (PHP)" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: PHP DB <php-db@lists.php.net> Subject: [PHP-DB] Verifying syntax executed correctly Date: Tue, 17 Oct 2006 22:35:28 -0400 If I give this command through PHP to mySQL mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query = "UPDATE `table` SET `last_activity_field` = '$current_date' WHERE `reference` = '$account_reference' LIMIT 1;"; mysql_query($query); mysql_close(); is there a way to know if it executed successfully? Ron
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php