closing an ODBC connection to mysql
| From: | ben | Date: | Tue, 18 Dec 2001 23:40:28 +0000 |
| Subject: | closing an ODBC connection to mysql | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-10998@lists.php.net to get a copy of this message | ||
Hello
I've installed mysql and php on W2K with IIS5.0 and I'm having some trouble
closing my connection, which is established via odbc.
I have been using the following php code to connect:
$link = odbc_connect("forum", "ben", "dulwich")
or die("Could not connect");
print "Connected successfully";
This connects successfully. I then execute my query, which returns a result.
All is fine so far.
Unfortunately, when I come to close the connection, I have a problem:
mysql_free_result ($result);
print "Connection about to be closed";
// Closing connection
odbc_close($link)
or die ("connection not closed");
It always prints "connection not closed". Is this because the connection is
not closing, or simply that the "or die" option is not applicable for the
statement "odbc_close()"? I've read the manual and been through tutorials
etc but haven't found any conclusive answers on this, and I'd be gratefull
for any help!
Thanks very much in advance.
Ben