[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    RE: [PHP-DB] sql problem
From:       Bastien Koert <bastien_k () hotmail ! com>
Date:       2007-12-16 16:30:20
Message-ID: BAY135-W32B6C04AB3F598439A19519D610 () phx ! gbl
[Download RAW message or body]


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/
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[prev in list] [next in list] [prev in thread] [next in thread]