Every value goes in as 1000

[wazo]

Hi guys


I am having a issue

When i import rows into my database. It put every value above 1000 as 1000

So even if it was 567843.56 it goes in as 1000

My field type is decimal(10,2)



So it should be ok? Thanks in advance for your help

[guido2004]

How do you do the import?

[wazo]

I import from a csv file and input via a mysql query

[guido2004]

PHP? Can you post the code?

[longneck]

change it to decimal(10,12)

[SJH]

Doesn't the second number have to be smaller than the first, longneck?