这个查询的问题是什么?


What is the issue with this query?

INSERT INTO [dbp_mod].[dbo].[Logs] (UserID, DB_Type, DB_Name, TableName, FieldName, OldValue, NewValue, SearchFields, SearchValues, Action, ActionIP, ActionTime) VALUES (1, 'DBF', 'E:'dbf'dbtest.dbf', 'E:'dbf'dbtest.dbf', 'f3', '8', '10', 'f1', '1', 'Edited', '192.168.2.124', GetDate());

这个查询有什么问题?它在Management Studio中正确运行,但是产生

Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in错误与PHP

$query = "INSERT INTO [dbo].[Logs] (UserID, DB_Type, DB_Name, TableName, FieldName, OldValue, NewValue, SearchFields, SearchValues, Action, ActionIP, ActionTime) 
        VALUES ($data[UserID], '$data[DB_Type]', '$data[DB_Name]', '$data[TableName]', '$data[FieldName]', '$data[OldValue]', '$data[NewValue]', '$data[SearchFields]', '$data[SearchValues]', '$data[Action]', '$data[ActionIP]', GetDate()); ";
    echo "<br>$query";
    if(!mssql_query($query, $db)){
        $successFlag = FALSE;
    } else {
        $successFlag = TRUE;
    }

我确定我选择了db, $db

INSERT INTO [dbp_mod].[dbo].[Logs] (UserID, DB_Type, DB_Name, TableName, FieldName, OldValue, NewValue, SearchFields, SearchValues, Action, ActionIP, ActionTime) VALUES (1, '', '', '', '', '', '', '', '', 'Logged in ', '192.168.2.124', GetDate());

在PHP和Management Studio中都可以使用

错误是与您的DB连接,而不是您的SQL。检查db句柄,看看问题是什么。

有哪些方法可以验证一个db句柄是"好的"?