http://www.php.net/manual/en/function.number-format.php bastien ---------------------------------------- > Date: Sun, 16 Dec 2007 17:17:41 +0600 > From: arafat.cse@xxxxxxxxx > To: php-db@xxxxxxxxxxxxx > Subject: 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
