sql problem

------=_Part_6854_28873814.1197803861314
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_6854_28873814.1197803861314--

RE: sql problem

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
>=20
> my problem in the following code
>=20
> INSERT INTO `test` ( `debit` )
> VALUES (
> '20000'
> )
> when i search it shows like this:
>=20
>=20
> SELECT debit FROM `test`
>=20
> output is :20000.
>=20
> but
> i have to show
>=20
> output :20,000.00
>=20
>=20
> 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.space=
s.live.com!
http://asksantaclaus.spaces.live.com/=

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php