PHP 4.0 Bug #5546: Mysql Update Bug
| From: | am at pixelhouse dot de | Date: | Thu, 13 Jul 2000 08:03:22 +0000 |
| Subject: | PHP 4.0 Bug #5546: Mysql Update Bug | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-24268@lists.php.net to get a copy of this message | ||
From: am@pixelhouse.de
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);
@mysql_select_db($_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