I'm now finding that persistent connections is allowing the temp table to remain. I have a sql query that creates the table and another that joins the temp table to another for a result set that I use. If I press refresh on the browser window I get an error that the sql query creating the table fails. I prepend a query that removes the table before the sql that creates it and then hit refresh and the query works. If I close the browser thus ending the session and reopen the browser and log in, the script fails to remove the temp table since it hasn't been created yet (and must have been removed). I changed my method of connecting to use mysql_connect instead of mysql_pconnect and removed the drop temp sql and it loads and reloads fine. Perhaps it is the combination of mysql_pconnect with sessions that creates this problem.
-----Original Message----- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:43 PM To: Larry Brown; PHP List Subject: Re: [PHP] php temp table question (for mysql) From: "Larry Brown" <[EMAIL PROTECTED]> > Does anyone know whether the use of persistent connections with php will > allow a temp table created by a script to linger around No, the table will still be removed at the end of the script whether you use persistant connections or not. > and cause a problem > with the next execution of the script when it tries to create the temp table Temporary tables are unique for that specific question. So you can have the same script creating the "same" temporary table and 100 people hit it without issues. Each script creates it's own temporary table with a unique name that only that connection has access to. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
