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 col1=@var1");
It worked this way!
It seems I musta had some other problem somewhere else thank you
Thank you all
MAuricio
>
> 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
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
