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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
