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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php