Re: mysql_close();
| From: | Michiel van Heusden | Date: | Fri, 21 Mar 2003 10:39:54 +0000 |
| Subject: | Re: mysql_close(); | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-140573@lists.php.net to get a copy of this message | ||
I've been told (in this newsgroup as well :) that PHP automatically closes
the MySQL connections on closing the file or session..
probably when you ended your last '?>' PHP closed the MySQL connection
a way to solve it is to insert the closing-command right after you finished
using the connection
and I don't really understand why you use if(etc...) and not just a plain:
mysql_close($connection);
but i suppose that doesn't make any difference
grace
michiel
"Shaun" <shaun@mania.plus.com> wrote in message
news:20030321095836.96275.qmail@pb1.pair.com...
> hi,
>
> I include a file called bottom.php which goes at the bottom of all my
pages
> and looks like this:
>
> <td> </td>
> </tr>
> </table>
> </body>
> </html>
> <?php
> if ($connection = @mysql_connect($host, $username, $password)){
> @mysql_close($connection);
> }
> ?>
>
> I use this to make sure that I haven't left a connection open
accidentally,
> however I sometimes get an error message even though I am using the @
> symbol:
>
>
> Warning: mysql_close(): no MySQL-Link resource supplied in
> /home/w/o/workmanagement/public_html/authenticate_user.php on line 51
>
> How can this be?
>
>