Re: [PHP] sessions and temporary tables

2002-06-18 Thread Jason Wong
On Tuesday 18 June 2002 17:21, Wilbert Enserink wrote: i have this problem: My Q: howcome mySQL is not able to find this temporary table anymore It seems to have destroyed this table when leaving the search.php page, but that's a rather odd idea, cause I thought it maintained while the

Re: [PHP] sessions and temporary tables

2002-06-18 Thread W. Enserink
, 2002 11:31 AM Subject: Re: [PHP] sessions and temporary tables On Tuesday 18 June 2002 17:21, Wilbert Enserink wrote: i have this problem: My Q: howcome mySQL is not able to find this temporary table anymore It seems to have destroyed this table when leaving the search.php page

RE: [PHP] sessions and temporary tables

2002-06-18 Thread Brian McGarvie
unless you open a persistent connection, connections are closed automatically at the end of execution of a script. -Original Message- From: W. Enserink [mailto:[EMAIL PROTECTED]] Sent: 18 June 2002 10:41 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] sessions and temporary tables

Re: [PHP] sessions and temporary tables

2002-06-18 Thread 1LT John W. Holmes
Temporary tables only exist for the duration of your script, with or without using mysql_pconnect(). If you want a MySQL table to remain, then don't make it temporary. Make it a regular table and then create a cron script that goes through and deletes tables that are more than X minutes/hours