ryanhart
Joined: 08 Apr 2004
Posts: 12
Posted: 2005-07-29 16:35
Back to top
Reply with quote
|
I can't figure out how to format currency with commas.
This is what I have so far...
example:
'mask' => '$%01.2f', = $123567.00
the result I want is: $123,567.00
I would appreciate any suggestions.
Thanks,
Ryan
|
guardian46
Joined: 31 May 2005
Posts: 34
Posted: 2005-07-29 22:38
Back to top
Reply with quote
|
Ryan,
Doug posted this for me in another thread and it works for me. I'm using the CVS ver 1.167 of phpMyEdit.class.php.
| Code: |
| $opts['fdd']['columnname']['sql|LF'] = 'if(columnname <> "0.00", CONCAT("$", FORMAT(columnname, 2)), columnname)'; |
replace columnname with your column.
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
