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)" <ron.php@xxxxxxxxxxxxxxxxxx>
Reply-To: ron.php@xxxxxxxxxxxxxxxxxx
To: PHP DB <php-db@xxxxxxxxxxxxx>
Subject: 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
