[RESOLVED] Number format of DECIMAL fields

NiallThistle

Can anyone advise on how to stop a DECIMAL field from displaying pointless decimal numbers?

I have quantity field that at the moment will always display three decimals places that I have specified in the table (i.e. its set to 10,3). Ideally, I'd like this field to only display the decimal places if the value of them are relevant.

I.e Instead of 2.30, it should just display 2.3. Or, if something is 16.00, it should only display 16.

awbrowni30

Use either of the following...

MySQL => set column field to decimal(8,0) or decimal(8,1)

-OR-

PHP => use the number_format function

samuelcook

It has been in my experience to use varchars in my sql db. In doing so, the field will read as an int and a charset in the blink of an eye. Decimal fields always turn into nightmares, when trying to select, and parse the field as 0.10 and 0.1.

I know its not very useful but maybe for someone in the future...

bradgrafelman

If it's numerical data, then it should be stored as such. Just because you want to display it as something else has little bearing on the matter.

To that end, it sounds like what the OP wants could be accomplished with something like:

$formatted_number = rtrim((string)$number), '0.');

(which, of course, also has an equivalent SQL expression).

NiallThistle

Thank you very much! That did it!

NiallThistle

Ah wait, in retrospect, this has created a slight problem, in that 10.00 now appears as '1'?

NiallThistle

Looked into rtrim some more.

This works a treat!

rtrim(trim($number, '0'), '.');