Problems porting from MySQL Server to MSSQL7 Server

Can anyone help me? Today I was informed that the backend for my project will not be MySQL, but MSSQL 7.0. No problems, I said, but after porting database from MySQL to MSSQL I find that the UPDATE statement doesn't work. Strange is that INSERT statement in a php query does not work second time (ie, i made a script for taking records from MySQL and insert in MSSQL; first query work, but second doesn't). Code is here: my_update("update sometable set col1=".$var1." where col2=".$var2); and function: function my_update($query){ global $host,$user,$psw,$name; $conn=mssql_pconnect($host,user,psw) or die("Error: connection failed!"); $rdb=mssql_select_db($name,$conn) or die("Error: DB does not exist"); $rez_q=mssql_query($query,$conn) or die("Error: Invalid SQL"); } The same code and function work fine in MySQL. Why doesn't work in MSSQL Server??? Adrian JURJICA ================================ Tel.: +40-94-128879 E-mail: adiju@terrasat.ro ================================ Nu ocoliti pe Internet: http://oneblackcat.f2s.com http://www.terrasat.ro http://www.transcondor.com http://aimmr.go.ro ================================