Thanks for the help i have got it correct.
--
View this message in context:
http://www.nabble.com/seoparator-help-tf4316769.html#a12568601
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
Learn something every day.
TFT
- Original Message -
> *From:* "Andrew Braithwaite" <[EMAIL PROTECTED]>
> *To:* "coolcoder" <[EMAIL PROTECTED]>,
> *Date:* Thu, 23 Aug 2007 14:19:25 +0100
>
> mysql> select format(300,0);
> +---+
> | format(300,0) |
> +
mysql> select format(300,0);
+---+
| format(300,0) |
+---+
| 3,000,000 |
+---+
1 row in set (0.00 sec)
mysql> select format(300,2);
+---+
| format(300,2) |
+---+
| 3,000,000.00 |
+-
Not really a MySQL problem, this is a presentation problem. MySQL will
store the number as digits only (unless you are storing in a character
field - but why would you?). If using PHP, for instance, the output of
the field would be
number_format($fieldvalue)
or if you want the answer to two d