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 col1=@var1");
2006/4/26, Mauricio Pellegrini <hrrg-inf@xxxxxxxxxxxxx>:
>
> 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 further
>
> //This is my first query
>
> $quer1=" SET @var1=3 ";//Here I`m suposed to set the value for var1 to 3
> mysql_query($quer1);
>
> // This is query #2
>
> $query2="SELECT * from table1 where col1=@var1 "//Here @var1 doesn`t
> exist
>
>
> That wasn't really my first attempt. Originally
> I've tryied the whole thing in just one single query but mysql gave me
> an error message complinning about the semicolon
>
> Please look at this
>
> $quer1 = "SET @var1=3 ;
> SELECt * from table1 Where col1=@var1 " ;
>
>
> This gave a syntax error from MySQL inmmediately before the ";"
> (semicolon),
>
>
> Please any help greatefully appreciated
>
> Thanks
> Mauricio
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
