AFAIK, temporary table is session based. i.e. only the session creating the temporary table can manipulate the table.
Wilbert Enserink wrote: > > hi all, > > 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.... > > anybody knows why? (mysql 3.23) > > thx Wilbert > > ------------------------- > Pas de Deux > Van Mierisstraat 25 > 2526 NM Den Haag > tel 070 4450855 > fax 070 4450852 > http://www.pdd.nl > [EMAIL PROTECTED] > ------------------------- > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php