[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-general
Subject:    Re: [PHP] php temp table question (for mysql)
From:       Marek Kilimajer <kilimajer () webglobe ! sk>
Date:       2003-10-31 19:46:19
[Download RAW message or body]

Session should not have any influence. Perhaps Keep-alive connection, 
then by closing the browser the connection ends. If you would wait 
enough the connection will be closed anyway.

But certainly this is valueable knowledge.

Larry Brown wrote:
> 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:holmes072000@charter.net]
> 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" <larry.brown@dimensionnetworks.com>
> 
>>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

[prev in list] [next in list] [prev in thread] [next in thread]