PHP and MySQL bug
| From: | Nuno Lopes | Date: | Sat, 04 Jan 2003 10:46:27 +0000 |
| Subject: | PHP and MySQL bug | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-130222@lists.php.net to get a copy of this message | ||
Dear Sirs,
I'm using PHP and MySQL to make my programs. But I think I discovered a bug
in PHP or in MySQL (I don't know!).
In one of my files I have the following:
MYSQL_CONNECT("localhost", "**user**", "**pass**");
mysql_select_db("be");
$r=MYSQL_QUERY("SELECT n,u,m,h FROM d WHERE id='$id'");
/* Some code including "mysql_num_rows" and "mysql_fetch_array($r,
MYSQL_NUM)"
And the another query:
*/
MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");
/* i don't know why but this doesn't work! But if I close the connection and
open another te query is done:*/
MYSQL_CLOSE();
MYSQL_CONNECT("localhost", "**user**", "**pass**");
mysql_select_db("be");
MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");
---------------
I don't know why is this? Because I'm used to do more than a query per
connection and this never happened!
I'm using Win 2k, Apache 2.0.43, MySQL 3.23.49-nt and PHP 4.3.
I hope you solve this,
Nuno Lopes