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.
extend life of temporary table
Moderator: General Moderators
- mikeeeeeeey
- Forum Contributor
- Posts: 130
- Joined: Mon Jul 03, 2006 4:17 am
- Location: Huddersfield, UK
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: extend life of temporary table
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)