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 [EMAIL PROTECTED]"); 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 <[EMAIL PROTECTED]>: > 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 [EMAIL PROTECTED] "//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 [EMAIL PROTECTED] " ; > > > 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