Нужна помощь php с mssql
Проблема такая не могу добавить в базу mssql
$row = mssql_fetch_object(mssql_query("select * from $table where login='".addslashes($_POST['login'])."'".($id>0?" and 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("[email protected]","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