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:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 10:20 AM
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
