[MSSQL] WHERE AND oder ,?

[_FightZ_]

Hello.


I have a problem in MSSQL.

<?php


		$msconnect = mssql_connect("localhost");
		$msdb = mssql_select_db("kal_db", $msconnect);
		$query = "UPDATE Skill SET Level = '55' WHERE Index = '32', PID = '610'";
	
		mssql_query($query);
?>

I defined 2 WHERE clause by putting a ", " betwen both values. but yea it allways gives me an error

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

if i seperate them with AND i get the same error -.-

Please help ;D.

[Bot_interesierter]

$query="UPDATE Skill SET Level = 55 WHERE Index = 32 && PID = 610";

müsste gehen und für Integer Konstanten kann man die ' auch weglassen soweit ich weiß.

[Fratyr]

ya know, "Index" is a Statement in MySQL ;D
Read the manual and lern to escape your SQL Strings!

$query = "UPDATE `Skill` SET `Level` = '55' WHERE `Index` = '32', `PID` = '610'";