Here is how I do it:
$query = "some query ";
$query.="some more of the same query ";
$query.="still more query ";
$query.="and so on... ";
$rst = mysql_query($query);
NOTE: you need to add a space at the end of each line (after the last word
and before the closing quotations) if you plan on continuing the query on
the next line, or else your SQL will be invalid.
Good luck,
Brett
----Original Message Follows----
From: "savaidis" <[EMAIL PROTECTED]>
To: "MySQL list \(E-mail\)" <[EMAIL PROTECTED]>
Subject: long query on php
Date: Wed, 6 Feb 2002 21:13:44 +0200
How is possible to pass a long query to MySQL server with php?
I mean i.e a "create table" statement with more than 400 chars.
Have I to use shorter "create" and then "alter"?
Thanks
Makis
---------------------------------------------------------------------
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
_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
