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 Subject: [PHP-DB] Verifying syntax executed correctl

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 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

[PHP-DB] Verifying syntax executed correctly

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

[PHP-DB] Oracle Intermittent Connection Problem

2006-10-17 Thread Rocky O'Leary
G'day, I've got a number of PHP4 scripts that work just fine under PHP4 on a Tru64 Unix server. Moving these over to PHP4 running on a Mac OS X server, I find that the OCILogin function intermittently fails [1] with the following error message: Warning: ocilogon(): OCIEnvNlsCreate() failed. Ther

[PHP-DB] [PEAR] help with FormBuilder and checkboxes

2006-10-17 Thread Marco Sottana
> marco schrieb: >> [code] >> function preGenerateForm() >> { >> $this->fb_preDefElements['alive'] = >> HTML_QuickForm:: >> createElement('advcheckbox','alive','Ali >> ve',null,null,$this->alive); >> } >> [/code] >> this code generate a only one checkbox.. >> i would like to generate a list of che