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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php