PHP/MySQL won't update decimal field
- by Serhiy
I have this query:
UPDATE table_name
SET field_1 = field_1 +100,
field_2 = field_2 +100,
field_3 = field_3 +100
WHERE id = 1
LIMIT 1;
Where Field_1 is regular integer, Field_2 is decimal(15,6) and Field_3 is double(15,6).
When I run this query from php script they update just field_1 and nothing happen with field_2 and field_3 they just stay as before. But when I run in phpMyAdmin it's work without any problems.
I'm tried to lock tables, make round() before run update, nothing help.
Please help... why I can't update decimal and float fields from php?
PHP version: 5.2
Mysql version 5
