running a big sql script

I have a complex query, that because of mysql's lack of resources became twice as big and complex. I had to create a temporary table and put stuff in it and then select data from it, cuz 'union' is not available... but I can't execute the whole script once, can I? like $sql="create temporary table tmp; insert into tmp select bla bla bla; "; $sql.="insert into tmp select bla bla; select * from tmp;"; I cant mysql_query($sql)... it gives me an error msg? Do I really have to run each step of the script as a separated query???? ____________________________ . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer