[PHP] How to execute multiples querys

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

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.

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 problem is this

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 suposed to be some

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 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, but after the

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 you try to run the query above (

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, but after the

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, but

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 inmmediately before the ;

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 thank

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] ; This

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 ?php mysql_connect('localhost',