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

bastien



----------------------------------------
> Date: Sun, 16 Dec 2007 17:17:41 +0600
> From: [EMAIL PROTECTED]
> To: php-db@lists.php.net
> Subject: [PHP-DB] sql problem
> 
> my problem in the  following code
> 
> INSERT INTO `test` ( `debit` )
> VALUES (
> '20000'
> )
> when i search it shows like this:
> 
> 
> SELECT  debit  FROM `test`
> 
> output is :20000.
> 
> but
> i have to show
> 
> output :20,000.00
> 
> 
> like
> input 20000
> output 20,000.00
> input 3000
> output 3,000.00
> input 100000
> output 1,00000.00

_________________________________________________________________
Read what Santa`s been up to! For all the latest, visit 
asksantaclaus.spaces.live.com!
http://asksantaclaus.spaces.live.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to