[PHP-DB] figures question
by =?iso-8859-1?q?JeRRy?= other posts by this author
Sep 27 2003 1:31PM messages near this date
[PHP-DB] Re: database design question
|
Re: [PHP-DB] figures question
Hi,
I have in my database a total value which looks like
this.
0.00000
If the figure is more than 9.99999 it goes to 10.00000
and so on.. The first 2 digits after the . is cents
and the following is part of a cent.
So it appears in the database for example like 7.51234
.. But I want to display it on a PHP page as 7.51 and
forget the remaining digits. Is it possible? I want
to leave the digits in place on the database but have
the output as the dollar value and 2 cent values.
Like This:
If under $10
$9.75
If over $10
$10.75
If over $100
$100.80
and so on, is it possible?
Thanks!
http://search.yahoo.com.au - Yahoo! Search
- Looking for more? Try the new Yahoo! Search
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thread:
=?iso-8859-1?q?JeRRy?=
Joe Nilson Zegarra Galvez
|