extend life of temporary table

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
mikeeeeeeey
Forum Contributor
Posts: 130
Joined: Mon Jul 03, 2006 4:17 am
Location: Huddersfield, UK

extend life of temporary table

Post 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.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: extend life of temporary table

Post 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.
(#10850)
Post Reply