Re: seoparator help

[coolcoder]

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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: seoparator help

[Terry Riley]

Learn something every day.

TFT

- Original Message -

 *From:* Andrew Braithwaite [EMAIL PROTECTED]
 *To:* coolcoder [EMAIL PROTECTED], mysql@lists.mysql.com
 *Date:* Thu, 23 Aug 2007 14:19:25 +0100
 
 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  |
 +---+
 1 row in set (0.00 sec)
 
 Cheers,
 
 Andrew 
 
 -Original Message-
 From: coolcoder [mailto:[EMAIL PROTECTED] 
 Sent: Thu, 23 August 2007 11:55
 To: mysql@lists.mysql.com
 Subject: seoparator help
 
 
 Was wondering if anyone could help me with this little problem I'm
 having.
 I'd like to have a comma separator after every 3 digits. E.g
 3,000,000.
 How would i go about this?
 
 
 
 
 
 
 This message has been scanned for viruses by BlackSpider MailControl 
 - www.blackspider.com
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 
 
 
 
 -- 
 No virus found in this incoming message.
 Checked by AVG. 
 Version: 7.5.484 / Virus Database: 269.12.2/967 - Release Date: 
 22/08/2007 18:51
 
 


Terry
http://booksihaveread.awardspace.co.uk


-- 
No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.484 / Virus Database: 269.12.4/969 - Release Date: 23/08/2007 16:04



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: seoparator help

[Terry Riley]

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 decimal places 

number_format($fieldvalue, 2)


Regards
Terry
http://booksihaveread.awardspace.co.uk
- Original Message -

 *From:* coolcoder [EMAIL PROTECTED]
 *To:* mysql@lists.mysql.com
 *Date:* Thu, 23 Aug 2007 03:55:27 -0700 (PDT)
 
 Was wondering if anyone could help me with this little problem I'm 
 having.
 I'd like to have a comma separator after every 3 digits. E.g 
 3,000,000.
 How would i go about this?
 
 
 
 
 
 
 www.coderewind.com
 Best Place to hunt for Code 
 -- 
 View this message in context: 
 http://www.nabble.com/seoparator-help-tf4316769.html#a12291343
 Sent from the MySQL - General mailing list archive at Nabble.com.



-- 
No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.484 / Virus Database: 269.12.2/967 - Release Date: 22/08/2007 18:51



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: seoparator help

[Andrew Braithwaite]

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  |
+---+
1 row in set (0.00 sec)

Cheers,

Andrew 

-Original Message-
From: coolcoder [mailto:[EMAIL PROTECTED] 
Sent: Thu, 23 August 2007 11:55
To: mysql@lists.mysql.com
Subject: seoparator help


Was wondering if anyone could help me with this little problem I'm
having.
I'd like to have a comma separator after every 3 digits. E.g
3,000,000.
How would i go about this?






This message has been scanned for viruses by BlackSpider MailControl - 
www.blackspider.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]