Re: How to execute multiples querys,IT is SOLVED!!

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@speedy.com.ar>: > 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 > >