RE: [PHP] sessions and temporary tables
| From: | Brian McGarvie | Date: | Tue, 18 Jun 2002 09:46:11 +0000 |
| Subject: | RE: [PHP] sessions and temporary tables | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-102672@lists.php.net to get a copy of this message | ||
unless you open a persistent connection, connections are closed automatically at the end of
execution of a script.
> -----Original Message-----
> From: W. Enserink [mailto:enserink@pdd.nl]
> Sent: 18 June 2002 10:41 AM
> To: php-general@lists.php.net
> Subject: Re: [PHP] sessions and temporary tables
>
>
> ok, that's clear, thx.
> but still, I'm not closing any connection AFAIK.
> at least not explicitly. are there then other ways which
> cause the closing
> of this connection?
>
> thx Wilbert
>
>
>
>
> ----- Original Message -----
> From: "Jason Wong" <php-general@gremlins.com.hk>
> To: <php-general@lists.php.net>
> Sent: Tuesday, June 18, 2002 11:31 AM
> Subject: Re: [PHP] sessions and temporary tables
>
>
> > On Tuesday 18 June 2002 17:21, Wilbert Enserink wrote:
> >
> > > i have this problem:
> >
> > > My Q: howcome mySQL is not able to find this temporary table
> anymore....
> > > It seems to have destroyed this table when leaving the
> search.php page,
> but
> > > that's a rather odd idea, cause I thought it maintained while the
> session
> > > was still active...
> >
> > Well sessions have nothing to do with MySQL tables (temporary or
> otherwise).
> > The reason why your table doesn't exist anymore is probably
> because temp
> > tables are only there for the duration of a particular
> mysql connection.
> Once
> > the connection is closed the table is automatically purged.
> >
> > --
> > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
> > Open Source Software Systems Integrators
> > * Web Design & Hosting * Internet & Intranet Applications
> Development *
> >
> > /*
> > If you refuse to accept anything but the best you very often get it.
> > */
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>
> -------------------------
> Pas de Deux
> Van Mierisstraat 25
> 2526 NM Den Haag
> tel 070 4450855
> fax 070 4450852
> http://www.pdd.nl
> info@pdd.nl
> -------------------------
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>