On Wed, April 26, 2006 11:07 am, Martin Alterisio wrote:
> You should be able to do this in two calls to the mysql_query()
> function.
> mysql_query("SET @var1=3");
> mysql_query("SELECT * from table1 Where [EMAIL PROTECTED]");
-bash-2.05b$ php -a
Interactive mode enabled
X-Powered-By: PHP/4.4.1
On Wed, 2006-04-26 at 13:48, Robert Cummings wrote:
> On Wed, 2006-04-26 at 10:36, Mauricio Pellegrini wrote:
> > On Wed, 2006-04-26 at 11:09, nicolas figaro wrote:
> > > Mauricio Pellegrini a écrit :
> > > >>> $quer1 = "SET @var1=3 ;
> > > >>> SELECt * from table1 Where [EMAIL PROTECTED] " ;
On Wed, 2006-04-26 at 13:07, Martin Alterisio wrote:
> You should be able to do this in two calls to the mysql_query()
> function.
> mysql_query("SET @var1=3");
> mysql_query("SELECT * from table1 Where [EMAIL PROTECTED]");
It worked this way!
It seems I musta had some other problem somewhere else
On Wed, 2006-04-26 at 10:36, Mauricio Pellegrini wrote:
> On Wed, 2006-04-26 at 11:09, nicolas figaro wrote:
> > Mauricio Pellegrini a écrit :
> > >>> $quer1 = "SET @var1=3 ;
> > >>> SELECt * from table1 Where [EMAIL PROTECTED] " ;
> > >>>
> > >>>
> > >>> This gave a syntax error from MySQL
You should be able to do this in two calls to the mysql_query() function.
mysql_query("SET @var1=3");
mysql_query("SELECT * from table1 Where [EMAIL PROTECTED]");
2006/4/26, Mauricio Pellegrini <[EMAIL PROTECTED]>:
>
> Hi all
>
> I'm trying to execute two querys and they execute perfectly in fact,
On Wed, 2006-04-26 at 11:04, chris smith wrote:
> On 4/26/06, Mauricio Pellegrini <[EMAIL PROTECTED]> wrote:
> > On Wed, 2006-04-26 at 10:32, nicolas figaro wrote:
> > > Mauricio Pellegrini a écrit :
> > > > Hi all
> > > >
> > > > I'm trying to execute two querys and they execute perfectly in fact,
On Wed, 2006-04-26 at 11:09, nicolas figaro wrote:
> Mauricio Pellegrini a écrit :
> >>> $quer1 = "SET @var1=3 ;
> >>> SELECt * from table1 Where [EMAIL PROTECTED] " ;
> >>>
> >>>
> >>> This gave a syntax error from MySQL inmmediately before the ";"
> >>> (semicolon),
> >>>
> >>>
> did y
On Wed, 2006-04-26 at 11:04, chris smith wrote:
> On 4/26/06, Mauricio Pellegrini <[EMAIL PROTECTED]> wrote:
> > On Wed, 2006-04-26 at 10:32, nicolas figaro wrote:
> > > Mauricio Pellegrini a écrit :
> > > > Hi all
> > > >
> > > > I'm trying to execute two querys and they execute perfectly in fact,
Mauricio Pellegrini a écrit :
$quer1 = "SET @var1=3 ;
SELECt * from table1 Where [EMAIL PROTECTED] " ;
This gave a syntax error from MySQL inmmediately before the ";"
(semicolon),
did you try to run the query above
( SET @var1=3 ; SELECt * from table1 Where [EMAIL PROTECTED] )
On 4/26/06, Mauricio Pellegrini <[EMAIL PROTECTED]> wrote:
> On Wed, 2006-04-26 at 10:32, nicolas figaro wrote:
> > Mauricio Pellegrini a écrit :
> > > Hi all
> > >
> > > I'm trying to execute two querys and they execute perfectly in fact,
> > > but after the execution of the first query there supo
On Wed, 2006-04-26 at 10:32, nicolas figaro wrote:
> Mauricio Pellegrini a écrit :
> > Hi all
> >
> > I'm trying to execute two querys and they execute perfectly in fact,
> > but after the execution of the first query there suposed to be some
> > variable setted to a certain value.
> >
> > The pro
Mauricio Pellegrini a écrit :
Hi all
I'm trying to execute two querys and they execute perfectly in fact,
but after the execution of the first query there suposed to be some
variable setted to a certain value.
The problem is this variable is not available at the time the second
query runs.
Hi all
I'm trying to execute two querys and they execute perfectly in fact,
but after the execution of the first query there suposed to be some
variable setted to a certain value.
The problem is this variable is not available at the time the second
query runs.
I`ll try to explain a little bit
13 matches
Mail list logo
