Posted by Oli Filth on 10/15/05 02:59

Jay said the following on 14/10/2005 14:57:
> Hey there,
> I have a question. Is it possible to to construct something through
> a combination of php and javascript that (when a browser window is
> closed)

No.

> would drop temp tables that are used? I've tried to use an
> override of the SESSION functions, but that isn't working in the way I
> would like it to. I go into mysql and can see that the temp tables that
> were created for the user are still in the database. Also, I would have
> liked to have used mysql's temp tables, but those tables don't seem to
> be maintained across different pages in one session. When a user goes
> from one page to another, those temp tables are gone. Any suggestions?
>

Temporary tables are exactly that - temporary. They are designed to be
used for a short period of time, e.g. within one SQL transaction.

If you require data for longer periods of time, you should re-think your
data structure/processing.

What sort of information are you using your temp tables for?

--
Oli

[Back to original message]