Number display from mysql

[graham23s]

Hi Guys,

 

in my database i have the correct price next to each item say for example 9.90 to get to that i times the "quantity" by the item "price" it stores as 9.90 in mysql, but when i get the results from mysql it only displays 9.9 it leaves out the zero

 

so:

 

$total_price = $product_price * $product_qty;

 

(which makes 9.90, i then update mysql it STORES 9.90)

 

when i fetch the data to display it only gets 9.9

 

is there some kind of formatting i need to do?

 

cheers

 

Graham

[AndyB]

http://ca.php.net/manual/en/function.number-format.php

[darkfreaks]

lookup the sprintf function

[graham23s]

Hi Guys,

 

so i have 9.90 stored in mysql, when i fetch it from mysql to print out , it only shows 9.9, number_format seems to round it up to 10, so sprintf is the way to go, ill check that out thanks mate

 

Graham

[AndyB]

number_format seems to round it up to 10 ...

 

Only if you don't declare it more fully

 

$nice_number = number_format($number, 2);// define decimal size