ID: 9497
Updated by: sniper
Old-Status: Open
Status: Closed
Bug Type: MySQL related
Assigned To: 

>From NEWS file:
- Fixed mysql_close(), pg_close(), msql_close() and sybase_close() - they
  weren't properly closing the SQL connections (Zeev)

Read also the manual page for mysql_connect() :

Where it says:

"If a second call is made to mysql_connect() with the same arguments, no new link 
will be established, but instead, the link identifier of the already opened link will 
returned. "

ie. You relied on buggy behaviour of mysql_close() function.


Previous Comments:

[2001-02-28 08:55:55] [EMAIL PROTECTED]
in file

function func1($blabla) {
   $conn = mysql_connect ("host","user","pass");
   $resset=mysql_query("SELECT a,b,c FROM ATable",$conn);


file index.php:
include ("");

$conn_main = mysql_connect ("host","user","pass");

$resset=mysql_query("SELECT a,b,c FROM ATable",$conn_main); <-- this statement works 
and returns a result
func1($abc); <-- call defined function
$resset=mysql_query("SELECT a,b,c FROM ATable",$conn_main); <-- after calling the 
above defined function i get an error: warning: 1 is not a valid mysql link resource


so thats the problem:
i have a script that makes a mysql connection. i can select, update, insert aso. from 
the db. then i call a function that itself makes a connection to the same db, does 
something with it (works fine) closes the connection and returns. i dont use global or 
give the main connection as an argument, its just a plain standalone function. after 
calling the function the main script has lost its mysql connection (its no timeout 
since the function doesnt take long to execute).

the same scripts work with PHP version 4.0.1pl2. both pcs have the same setup (apache 
1.3.12, mysql 3.22.32, the rest as rpms from the distibution cds). its all the same 
except the php-version (both compiled with the standard options --with-apxs 
--with-mysql -> make -> make install)


ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to