[ReneG]

Quote:

Originally Posted by [HLF]Southclaw Код: UPDATE `Player` (`data1`, `data2`, `data3`) VALUES('%d', '%d', '%d') WHERE `name` = '%s'

Excluding the WHERE clause and everything after it, that syntax is only for using the INSERT clause.

To update more than one value, you must follow this syntax.

Example

pawn Код:

UPDATE `Users` SET Password = '%s', Level = %d, AdminLevel = %d WHERE `Name` = '%s'

SQL is like talking.

That query will update the Users table by setting password = x, level = x, adminlevel = x only WHERE the Name = x.

You can also add more checks by using the AND clause.

pawn Код:

UPDATE `Users` SET Password = '%s', Level = %d, AdminLevel = %d WHERE Name = '%s' AND Regged = 1