RE: [PHP] running a big sql script

Yes you do. It comes easier for eyes if you use a database abstraction layer, but still it's a different query. Cheers, Maxim Maletsky -----Original Message----- From: Christian Dechery [mailto:lemming@vento.com.br] Sent: Tuesday, February 20, 2001 10:20 AM To: php-general@lists.php.net Subject: [PHP] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net