Re: 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 -------------------------