RE: Temporary table issues. Do I need persistent connections with php?

2004-02-18 Thread Agrin, Nathan
Kind of what I was thinking of. How can I generate a unique identifier? -Nate -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 2:18 PM To: [EMAIL PROTECTED] Subject: Re: Temporary table issues. Do I need persistent connections with

Re: Temporary table issues. Do I need persistent connections with php?

2004-02-18 Thread Keith C. Ivey
Even with persistent connections, you can't use a temporary table on a later HTTP connection (Web request), because you don't know that your new HTTP connection will get the same MySQL connection that you used before. It should work to use a temporary table in a series of queries to get data t

Temporary table issues. Do I need persistent connections with php?

2004-02-18 Thread Agrin, Nathan
I have a php page which displays quite a bit of dynamically calculated data which I need to be sortable using different SQL statements. Currently to display this data, a user browses to the page, the page checks for a cookie, if the cookie doesn't exist it includes some php to generate a temporary