On Mon, 2002-11-18 at 15:06, [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > On Sun, 2002-11-17 at 00:08, Dan wrote: > > > So I'd like to either keep the connection open across multiple php pages > > if possible, or just create normal tables and then delete them when I'm > > done. But the 2nd way would mean I'd have to check for the existance of > > the table before making it, in case someone else is logged in and > > already has their own tmp tables... But I don't know how to check for > > the existance of tables. > > > > How should I go about this? > > > > Thanks in advance! > > Here's how I would do it: > > CREATE TABLE temptablelist ( > id INTEGER NOT NULL auto_increment, > creation DATETIME, > user VARCHAR(100) > ); > > Then name your tables "mytemptable_$id", and DROP them in a cron every > so often if they're more than $some_max_age old. > > HTH > >
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php