Re: [PHP-DB] Verifying syntax executed correctly

2006-10-17 Thread Chris
Ron Piggott (PHP) wrote: 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

Re: [PHP-DB] Verifying syntax executed correctly

2006-10-17 Thread Niel Archer
Hi All of the MySQL functions you used, return FALSE on failure. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Verifying syntax executed correctly

2006-10-17 Thread Bastien Koert
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