FORMfields, the premiere web framework
Support Home | Knowledge Base | Documentation | Forums | Contact Us
FORMfields & FORMgen :: Database

Format a Currency Amount Using a MySQL Query

(2001 views. Last Updated: 2007-08-09 1:10 PM)

Let's say you have a database attribute called "cost." You can use something like the following in a TableSet query:
SELECT CONCAT('$', cost) FROM mytable
Support | Earn Money
Copyright © 2005-2019 Brain Book Software LLC.
Built with FORMfields, the premiere web framework.