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???


You need to fully examine your SQL statements against the format that MSSQL
wants to see.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to