Since PHP ignores whitespace, I think this is also acceptable: $query = "CREATE TABLE query tabledef for col a, tabledef for col b, lots more table defs, ..... welcome to line 400";
I have been using this technique and have not had any problems with it. If you echo $query, it's all on the same line. # Nathan ----- Original Message ----- From: "Johnny Withers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 10:36 AM Subject: RE: long query on php Or you could do it like this: $query="some query " ."some more of this query " ."still some more query " ."and so on and so forth...;" ; The tabs are no needed, I just put them there to make it easy to understand that all those lines are actually just one line. --------------------- Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -----Original Message----- From: Brett Burgess [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:25 AM To: [EMAIL PROTECTED] Subject: Re: long query on php 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 --------------------------------------------------------------------- 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
