Москва

Россия

Проблема такая не могу добавить в базу mssql 

 $row = mssql_fetch_object(mssql_query("select * from $table where login='".addslashes($_POST['login'])."'".($id>0?" and id<>$id":"")));
   
File:function.php
function AddRecord($table,$arr,$return_id=true){
    global $DB_LINK;

    $arr=array_change_key_case($arr,CASE_LOWER);

    foreach($arr as $key=>$value){
        if (!is_null($value)&&!(is_string($value)&&($value=="NULL"))){
            $fields .= '`'.strtolower($key).'`,';
            $values .= "'".$value."',";
        }
    }
    $query = "INSERT INTO `$table` (".substr($fields,0,strlen($fields)-1).") VALUES (".substr($values,0,strlen($values)-1).");";

    $res = mssql_query($query);
    if (!$res) {
        error_log(mssql_error());
        $_SESSION['ERROR_MSG'] = "Error. Probably there is an interdiction on this operation in DATABASE.";
        @mail("sup@sup.ru","Partner mssqlAddRecord error",$query);
    }
    elseif($return_id){
        $query="select max(id) from `$table`;";
        $res=@mssql_fetch_assoc(@mssql_query($query));
    }
    return $res["max(id)"];
}


проблема :

Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near '`'. (severity 15) in D:\bhu\includes\functions.php

Warning: mssql_query() [function.mssql-query]: Query failed in D:\bhu\includes\functions.php

Fatal error: Call to undefined function mssql_error() in D:\bhu\includes\functions.php 

думаю проблема с .addslashes 

кто разберается стучите в icq-433321424

Артем artem_dakin

Нужна помощь php с mssql