The obious question is: (before I test it) This is concatenation to $query that is a string type, no? So the limit isn't also set to 255 chars too? Or is a trick especially for this case?
Makis > -----Original Message----- > From: Johnny Withers [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 07, 2002 7:36 PM > To: [EMAIL PROTECTED] > 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
