temp table, php

[voodoochicken]

hi, i am using php with mysql. to do sql from php, you use mysql_query($query), which is a single query. is there any way to use temp tables in php with mysql query without using saved procedures? i ask because since mysql_query accepts a single query only, my guess is that once the query is finished, the temp table is no more so it wont be available for the next query, and since creating a temp table takes a query by itself, it can be used to do whatever it was intended to.if there is a way, could you post simple example?tnx