day, 8 February 2002 1:30 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
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
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 wro
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
l 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
He
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?
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 PROTECTE
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
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 t
c has 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
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 &quo
, 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 "
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
c has 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
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 t
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
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 wro
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 &quo
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 "
>
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 F
, 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 "
l 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
He
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
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 PROTECTE
24 matches
Mail list logo