salary. what phpmyadmin type - i used float

Forum|Forum|14 years ago
May 2, 2012
1 reply
4626 views

i have used float 6,2 for a salary but it doesnt show the correct figure,

if the applicant inputs 25,000 i need it to come out like that or 120,000

thanks

jon

Server side applications

This topic has been closed for replies.

C

cragthehack

Known Participant

Use decimal. See http://dev.mysql.com/doc/refman/5.5/en/fixed-point-types.html for more info.

But basically, 5,2 would get you 999.99, 5 being the total size of the field. So for salary I use 9,2. Also the presentation is not in the database but in your code. Assuming you are using PHP take a look at the number_format() function: http://php.net/manual/en/function.number-format.php.

And if you want to point and click, search the exchange for "number formats". There are probably a few extensons available.