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:[EMAIL PROTECTED] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
