Re: 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. */