temporary tables and mysql_connect

[mdowling]

I want to use temporary tables on my site that hold data from a query. Every page load I do this:

$Link = mysql_connect(....blah);

Does that cause all the data in the temporary table to be deleted? After I create the temporary table the first time, everything works fine. But, when I open another page and try to get some of the data stored in the temp table, there is nothing there.

So, I know the initial creation and insertion works, but it doesn't remain after I load a new page.

If the $Link every page is causing a problem, is there a way I could store the $Link data and only connect when I don't have a connection?

[frost110]

Session variable.

--FrosT

[Roger_Ramjet]

If your temporary table is being created with the Temporary keyword then it is lost as soon as the connection is closed. Opening any other connection has no effect on this, temp tables are specific to a specific connection and destroyed as soon as that connection is closed. Using persistent connections is not going to help you with this cos there is no guarantee that you will return to the same connection in the pool next time around, so you will probably end up with the wrong temp table from call to call.