RE: [PHP-DB] sql problem
| From: | Bastien Koert | Date: | Sun, 16 Dec 2007 16:30:20 +0000 |
| Subject: | RE: [PHP-DB] sql problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-44418@lists.php.net to get a copy of this message | ||
http://www.php.net/manual/en/function.number-format.php
bastien
----------------------------------------
> Date: Sun, 16 Dec 2007 17:17:41 +0600
> From: arafat.cse@gmail.com
> 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/