Re: [PHP] How to execute multiples querys

2006-04-26 Thread Richard Lynch
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

Re: [PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
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] " ;

Re: [PHP] How to execute multiples querys,IT is SOLVED!!

2006-04-26 Thread Mauricio Pellegrini
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

Re: [PHP] How to execute multiples querys

2006-04-26 Thread Robert Cummings
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

Re: [PHP] How to execute multiples querys

2006-04-26 Thread Martin Alterisio
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,

Re: [PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
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,

Re: [PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
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

Re: [PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
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,

Re: [PHP] How to execute multiples querys

2006-04-26 Thread nicolas figaro
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] )

Re: [PHP] How to execute multiples querys

2006-04-26 Thread chris smith
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

Re: [PHP] How to execute multiples querys

2006-04-26 Thread Mauricio Pellegrini
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

Re: [PHP] How to execute multiples querys

2006-04-26 Thread nicolas figaro
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.