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 php? 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 to display on a page in response to a single HTTP request, but if you need to save data through a series of HTTP requests (a session), you'll need normal tables. You can create a table using some unique ID in the name and then drop it when you're finished with it. It will exist temporarily, but it won't be a TEMPORARY table in the MySQL sense. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]