Re: How to execute multiples querys

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 col1=@var1 " ; > > > >>> > > > >>> > > > >>> 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 col1=@var1 ) > > > > > > directly from a mysql client ? > > > > Yes, I did and it Works perfectly. > > > > > > > perhaps the @ is interpreted and you have to put a \ before it. > > > try a print $quer1 once $quer1 is set. > > > > I've tried this too. The output is sintactically correct. > > I even copied the output of the query and pasted it to Mysqlcc an > > executed it perfectly. > > > > > > > > A few minutes ago I found that mysql_query() cannot execute more than > > one query at a time > > so the form mysql_query("SET @var1=3 ; SELECT * from ....") is invalid > > > > > > But the other way should work > > Try explicitly retrieving a resource ID from mysql_connect, and > explictly use that resource when making the query. Probably not the > problem, but sounds like something is being lost from one query to > another. Thank you that's true. Theres another module in the middle and that is getting only the last query Thanks to all Mauricio > > Cheers, > Rob.