sql problem
| From: | arafat uddin | Date: | Sun, 16 Dec 2007 11:17:41 +0000 |
| Subject: | sql problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44417@lists.php.net to get a copy of this message | ||
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