Page 1 of 1

extend life of temporary table

Posted: Wed Mar 05, 2008 7:10 am
by mikeeeeeeey
I'm trying to use a temporary table in MySQL to hold some results and then output them. However, when you navigate to the next/last page of results the table isn't there.

Is there any way to extend the life of this table or is this not possible?
I've tried using mysql_pconnect() when connecting to the database to keep it open but its not having any effect.

Re: extend life of temporary table

Posted: Wed Mar 05, 2008 11:21 am
by Christopher
Temporary tables are per connection, so will not work well with PHP. You should create a regular table or store the results in the session.