[RESOLVED] MySQL_Close function not working

jkurrle

I am using function #1 just fine throughout my webpages, but when I call it inside of function #2, I get the following error message:

Warning: mysql_close(): 11 is not a valid MySQL-Link resource in /usr/local/apache2/htdocs/S-and-S/triage/MSL/Event_Functions.php on line 506

I have no problem calling other similar functions, just this one. What should I be looking for to fix this?

herve

The "connection id" parameter of the mysql_close() call is quite surely not defined in the second function.

You need to add something like :

global $db;

inside the second fonction, where "$db" is the result of the mysql_connect() call.

If the mysql_connect() call is inside function # 1 you also need to add

global $db;

in the first function (to make it available for other functions)

jkurrle

I use a database connection in both functions. In function #1, I use the following line:

$connection1=Connect_To_DB();

where Connect_To_DB() is a function I wrote to make the connection automatically and return the connection as a variable back to the calling program.

In function #2, I use a similar line

$connection2=Connect_To_DB();

Now for my questions:

1) Why did this not prevent the connections from interfering with each other?

2) If I need to global one of my connections, which one does it need to be, Function #1, Function #2, or both?

Thanks for the assistance.

Roger_Ramjet

The reason that the connections interfered with each other is in the manual

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

To establish seperate connections you need to supply different connection parameters, such as a dirrent username or port number.

herve

And for question #2, the answer is : if it's the same connection, to the same database,
with the same user account & password, then you only need 1 connection, all in all.

You need to put the result in a global variable and use it like any global variable.
(cf my previous message)

jkurrle

Thank you all very much. This was what I needed to know. I adjusted my code to accomodate one database connection at a time and it works just fine now.

herve

Great 🙂