Im using PHP 4.0.6 install on Solaris x86 with mysql 3.23.39.  The following code 
causes mysql_query to return false, but the
database update works!

$query .= "WHERE User_Name = '$User_Name[$i]'" ;
    $sth = mysql_query($query) or die ("<p>ERROR: Update Query Failed<p>$query<BR>") ;
    if ($verbose) {
        print ("$query<BR>");

Here is the error message generated by the code:
ERROR: Update Query Failed
UPDATE Padmin SET Full_Name = 'Corin Cody', Admin = 1 WHERE User_Name = 'ccody'

I was recieving the following warning from the code above until I changed 
error_reporting = E_ERROR
Warning: MySQL: Unable to save result set in
 on line 26

Here are my PHP build options:
CC=gcc OPTIM="-O2" EXTRA_LIBS=/usr/local/lib LIBS=-lz
./configure  --with-apxs=/usr/local/httpd/bin/apxs --with-mysql=/usr/local/mysql/ 
--with-png-dir=/usr/local/lib/ --with-i
map=/usr/local/lib --with-lz=/usr/local/lib

Any ideas?


PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to