Number formatting and decimal places

[12dstring]

I have a field in my database which has numbers varying from 0.35 to 60000, and when I output them on my php page, I want the decimal places on the small ones to be shown, but without the large ones appearing with them, ie 60000.00.

I've tried all of the different formats, float, decimal, double... but they all seem to either cut the decimals off or have them all on.

 

Is there one which automatically cuts off extra zeros after the decimal place?

 

Thanks,

Dave

[fenway]

You need a conditional format... either do this in mysql with a if, or do it on output only.

[Wildbug]

You can use an IF statement to control the format used.

 

IF(FLOOR(val)=val,FORMAT(val,0),FORMAT(val,2))