Precision problem with PHP/MySql...

[tristero]

i have a table with a field (float) with the value "1.80" in it.


when i pull that value into a php page, the "0" is lopped off, and i just get "1.80"

how do I get the entire "1.80" to show (without changing the field to varchar)?

thanks

Dan Trenz
Ann Arbor, MI

 

[tristero]

that should read:

when i pull that value into a php page, the "0" is lopped off, and i just get "1.8"

Dan Trenz
Ann Arbor, MI

 

[Chacalinc]

use printf or sprinf:

http://cl2.php.net/manual/en/function.sprintf.php

 

[tristero]

thank you!


if anyone wants an easy currency formatting function... i just added this so i could just do Money($amount) to any currency floats..

function Money($float) {

	return sprintf("%01.2f", $float);

}

Dan Trenz
Ann Arbor, MI

 

[sleipnir214]

If you're not running on Win32, there's also the builtin function money_format()

Want the best answers? Ask the best questions!

TANSTAAFL!!