RE: [PHP-DB] Verifying syntax executed correctly
| From: | Bastien Koert | Date: | Wed, 18 Oct 2006 03:25:25 +0000 |
| Subject: | RE: [PHP-DB] Verifying syntax executed correctly | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42575@lists.php.net to get a copy of this message | ||
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@actsministries.org> Reply-To: ron.php@actsministries.org 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 = "UPDATEtableSETlast_activity_field= '$current_date' WHEREreference= '$account_reference' LIMIT 1;"; mysql_query($query); mysql_close(); is there a way to know if it executed successfully? Ron