RE: [PHP] php temp table question (for mysql)

On Larry Brown wrote:
---------------------
Does anyone know whether the use of persistent connections with php will
allow a temp table created by a script to linger around and cause a
problem
with the next execution of the script when it tries to create the temp
table
again? Also if it does present a problem with the next script execution
trying to create the temp table again, if I drop the temp table at the
end
of the script will I still have problems if the script is run by two
client
in tandem? For instance two people connect, both hit the script at
about
the same time. One script creates the temp table and before it can drop
the
table the second script tries to create the table. Will it see the
table
created by the other script? Again the use of persistent connections
would
be a the heart of this I would think.
---------------------

Perhapds you could add a check at the beginning of the script to see if
the table exists, and if the table does not exist then you create it.
If it does exist, you use the existing table.

Cheers,
Pablo

-----Original Message-----
From: Larry Brown [mailto:larry.brown@dimensionnetworks.com]
Sent: Monday, October 27, 2003 1:24 PM
To: PHP List
Subject: [php] php temp table question (for mysql)



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php