RE: temporary table

[Hendrik Schalekamp]

Wilbert:
> i have this php script which queries a table. The results are 
> stored in a
> temprrary table
> "CREATE temporary TABLE t1 SELECT .....statements...";
 
> when I query this table in the same script i can see that the 
> results wore
> indeed stored in t1.
 
> however when i call this table from a different script I get 
> the error thet
> t1 doesn't exists....

I beliebe this is because temporary tables are only accessible from (and in) the session
in which they are created, once the session closes the tables dissapear. Do a search for
"temporary" in the MySQL manual (http://www.mysql.com) for more info on temporary tables.

-H