At 03:04 PM 10/27/2003, you 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
It won't. If the client looses its connection, the temp table will disappear.
> 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
It will drop itself if the client looses their connection. You can have
many people using a temporary table called "problems" and the table will be
different for each client. It is only used for that connection and can NOT
be shared by other clients. Each has their own.
> 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?
Neither peoples connection will ever see the others temporary table and so
both people will have the same name for a temporary table, but they would
have their own, not a shared table like a permanent one that is in the
> Again the use of persistent connections would
>be a the heart of this I would think.