MYSQL Error

[iToxiicz]

Right , SO i try to give someone a Badge for PD , Which for me is item ID 64 , And i get this;

[2011-08-13 02:44:06] INFO: Incorrect integer value: 'asf' for column 'itemValue' at row 1

I put ASF As the value to test it , Also the item values do not save... Why is this? O_O

[SHC//Sniper]

Sry for posting at this old topic but he should get the solution.

Well, you can't update an INTeger column with a string value like 'asf', it must be a number.

The query will look like that. Do not use ' ' if you want to update an INT column.

UPDATE table SET itemValue = 64 [...]