[PHP-DEV] PHP 4.0 Bug #5546: Mysql Update Bug From: am <email protected>
Date: 07/13/00

From: am <email protected>
Operating system: Linux Redhat 6.2
PHP version: 4.0.1pl2
PHP Bug Type: MySQL related
Bug description: Mysql Update Bug

Hi...

I have php4.01pl2 running on Redhat 6.2.
I start querrying Databases like this.

$link = mysql_connect($_Server,$_User,$_Spasswort);
 <email protected>($_Database,$link);
$result = mysql_fetch_array(mysql_query("select * from User where UID = '$TransID' and UsrTemp ='1' "));

The mysql_fetch_array works fine and all values are returned.

But if i make this at next.

$tempo = mysql_query("update User set UsrTemp='0' where UID = '$TransID' ");

This error appears:
Warning: MySQL: Unable to save result set in /www/httpd/foo.de/html/paygate/successcc.phtml on line 24

But the querry does in the Database what it has to do so there should no error be returned.
The querry works but the errormessage comes.

So what to do to fix this?

Regards

Alex
                 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>