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
