Page 1 of 1

Numbers

Posted: 2013-03-11 18:43
by jstrick
Ok not sure if doing this correct but here we go.

I have a field called time i made it a decimal 2,2 and it works fine in one table BUT

In another table i just made i made a field with the same setting and it keeps rounding to 0.99
Changed it to an integar and it rounds to 2.
Any ideals how to fix this.

Ironically when i look in the table in php the first table is saved in app as a decimal but in php it shows var char.

Any ideals would help.

Re: Numbers

Posted: 2013-04-15 23:18
by jstrick
OK Just an fYI I finally changed the field to var char in the PHP table and this fixed the issue.