insert query in sql server

[jonker]

When I try to insert a row in the SQL server. I received these warnings :

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'transactions'. (severity 16) in C:\aisservice\aisservice\inc\database\mssql.php on line 169

Warning: mssql_query() [function.mssql-query]: Query failed in C:\aisservice\aisservice\inc\database\mssql.php on line 169
INSERT INTO users (login,domain,email,credit,entrance_bonus)VALUES ('klaas','klaas','klaas',0,6.00)

The record is inserted in the database. But what is wrong? When starting a SELECT query everthing is running fine. When doing an update same message appears.

Who can tell me more about this.
Many thanks in advance

Richard

[devinemke]

try your query syntax like this:

INSERT INTO users SET
login = 'klaas',
domain = 'klaas',
email = 'klaas',
credit = '0',
entrance_bonus = '6.00'

[Bunkermaster]

check for reserved words

[jonker]

Thanx,

The field login is reserved

Richard

[Bunkermaster]

Click "Mark This Thread Resolved" please 🙂
And you're welcome.