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

Reply via email to