Москва

Россия

Проблема такая не могу добавить в базу 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

Проблема такая не могу добавить в базу mssql 

 $row = mssql_fetch_object(mssql_query("select * from $table where login='".addslashes($_POST['login'])."'".($id&gt;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=&gt;$value){
 if (!is_null($value)&amp;&amp;!(is_string($value)&amp;&amp;($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