How to display two decimal places in MYSQL / PHP?

Question

I would like to display £ 2.00 instead of £ 2 or £ 3.50 instead of £ 3.5 .

These numbers say it priceis defined as DOUBLEin a MySQL database. How to get MySQL or PHP to display two decimal places?

Many thanks!

+3

nuvio May 11 '12 at 21:48

4 answers

For MySQL you can use the function format:

SELECT FORMAT(1.2345, 2);

He will return 1.23

For PHP you can use in a number_formatsimilar way:

echo number_format(1.2345, 2);

Also stamp 1.23

+9

+5

bfavaretto 11 '12 21:50

, .

, , DOUBLE - , .

, DOUBLE ; , . , , , . MySQL , DECIMAL, (.. ) .

+4

eggyal 11 '12 23:22

Jeroen · Accepted Answer · 2012-05-11T21:50:51+0000

Try the following:

echo number_format ($price, 2);