How would I insert a variable into MSSQL Database from php?

Question

  mssql_query("INSERT into User_Shoutbox(user,message) VALUES('$user','$message')",$dbhandle );

This code inserts the Variables User and Message into the database. But this code keeps giving me an error...

message: Incorrect syntax near the keyword 'user'. (severity 15) in Shoutbox.php on line 36

So how do I insert the variables into the Database properly?

Nitin Jindal · Accepted Answer · 2010-12-25 07:55:32Z

1

$query="INSERT into User_Shoutbox (user,message) VALUES('$user','$message')"; mssql_query($query,$dbhandle );

answered Dec 25, 2010 at 7:55

Nitin Jindal

2583 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

This is result Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'user'. (severity 15) in

Which the collum does exists?

Kalessin · Accepted Answer · 2011-01-06 20:11:15Z

0

You're probably not still stuck on this, but "user" is a protected keyword in SQLServer.

mssql_query("INSERT into [User_Shoutbox] ( [user], [message] ) 
VALUES( '$user', '$message' )", $dbhandle );

answered Jan 6, 2011 at 20:11

Kalessin

2,3022 gold badges22 silver badges24 bronze badges