Re: php temp table question (for mysql)

* Thus wrote Larry Brown (larry.brown@dimensionnetworks.com): > 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 How are you creating the temp table? > 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. If this is the case it most likey is a mysql issue not a php one. Curt -- "My PHP key is worn out" PHP List stats since 1997: http://zirzow.dyndns.org/html/mlists/