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
Hi.
I prefer doing like this
$query = CREATE TABLE query ;
$query .= tabledef for col a,;
$query .= tabledef for col b,;
$query .= lots more table defs,;
$query .= welcome to line 400;
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wrote:
Yesterday, from savaidis:
The obious question is: (before I test it)
This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query(create bla.
bla.
bla
bla blabla
.
bla
.bla
);
So the limit isn't also set to
a.m.
To: 'MySQL list (E-mail)'
Subject: RE: long query on php
Have you tried just putting the querys into a variable and pass the var
along to mysql_query() ? Did it not work?
---
Alain Fontaine
Consultant Developer
VAlain S.A.
Tel: +32-4-2522950
Surprisingly it is mote than 64 KB! (I count strlen=74KB)
Bravo!!
Makis
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:08 AM
To: [EMAIL PROTECTED]; 'Nathan'
Cc: 'MySQL'
Subject: RE: long query on php
Just a comment:
Doing so
Have you tried just putting the querys into a variable and pass the var
along to mysql_query() ? Did it not work?
---
Alain Fontaine
Consultant Developer
VAlain S.A.
Tel: +32-4-2522950
---
-Original Message-
From: savaidis [mailto:[EMAIL
It shouldn't be a problem as long as the syntax is right...
Gurhan
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:14 PM
To: MySQL list (E-mail)
Subject: long query on php
How is possible to pass a long query to MySQL server with php?
.
-
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
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
[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
this high limit, no?
Makis
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 3:03 AM
To: Nathan
Cc: MySQL
Subject: Re: long query on php
Hi.
I prefer doing like this
$query = CREATE TABLE query ;
$query .= tabledef for col
Yesterday, from Nathan:
Since PHP ignores whitespace, I think this is also acceptable:
PHP doesn't ignore whitespace in a quote. But your code is of course
correct.
$query = CREATE TABLE query
tabledef for col a,
tabledef for col b,
lots more table defs,
.
welcome to line
this high limit, no?
Makis
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 3:03 AM
To: Nathan
Cc: MySQL
Subject: Re: long query on php
Hi.
I prefer doing like this
$query = CREATE TABLE query ;
$query .= tabledef for col
Surprisingly it is mote than 64 KB! (I count strlen=74KB)
Bravo!!
Makis
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 08, 2002 9:08 AM
To: [EMAIL PROTECTED]; 'Nathan'
Cc: 'MySQL'
Subject: RE: long query on php
Just a comment:
Doing so
Have you tried just putting the querys into a variable and pass the var
along to mysql_query() ? Did it not work?
---
Alain Fontaine
Consultant Developer
VAlain S.A.
Tel: +32-4-2522950
---
-Original Message-
From: savaidis [mailto:[EMAIL
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
: RE: long query on php
Have you tried just putting the querys into a variable and
pass the var
along to mysql_query() ? Did it not work?
---
Alain Fontaine
Consultant Developer
VAlain S.A.
Tel: +32-4-2522950
---
-Original Message-
From
, 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
[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
Hi.
I prefer doing like this
$query = CREATE TABLE query ;
$query .= tabledef for col a,;
$query .= tabledef for col b,;
$query .= lots more table defs,;
$query .= welcome to line 400;
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wrote:
Yesterday, from savaidis:
The obious question is: (before I test it)
This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query(create bla.
bla.
bla
bla blabla
.
bla
.bla
);
So the limit isn't also set to
Yesterday, from Nathan:
Since PHP ignores whitespace, I think this is also acceptable:
PHP doesn't ignore whitespace in a quote. But your code is of course
correct.
$query = CREATE TABLE query
tabledef for col a,
tabledef for col b,
lots more table defs,
.
welcome to line
22 matches
Mail list logo