For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > December 2007 > RE: [PHP-DB] sql problem









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author RE: [PHP-DB] sql problem
Bastien Koert

2007-12-16, 6:59 pm


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/=
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com