PHP 4.0 Bug #9049: mysqlconnect works, but mysql_query says invalid resource - with 4.0.3pl1 okay

From: administrator@rtl.lu Operating system: Linux 2.2.x PHP version: 4.0.4pl1 PHP Bug Type: MySQL related Bug description: mysqlconnect works, but mysql_query says invalid resource - with 4.0.3pl1 okay I have a script which is connecting to mysql using $authdb=mysql_connect ...... mysql_error does not report an error, neither using the select_db function. Later in the same script, I use a mysql_query, which is reporting invalid mysql_resource (where i do an echo of the $authdb, which reports a correct handle). If I move the mysql_connect & mysql_select_db jhust in the lines before the mysql_query, it is working fine also mysql_close($authdb) does not report an error anymore. This only occurs under 4.0.4pl1, where under 4.0.3pl1 the same script is working fine, without any problems. I use exactly the same configure line as 4.0.3pl1 ( built-in mysql support). Now I downgraded again, scripts are running okay now. I tried also with/without optimizer on both versions, same results. --------------------------------------------- Tom Weber Responsable Technique Internet Internet Technical Manager RTL Radio & Télé Lëtzebuerg / RTL Group Mail : administrator@rtl.lu URL : http://www.rtl.lu -- Edit Bug report at: http://bugs.php.net/?id=9049&edit=1