Format Price
2 posts by 1 authors in: Forums > CMS Builder
Last Post: May 8, 2009 (RSS)
By pjd218 - May 8, 2009
I need to sort lsitings based on price. Got that working. however, I have to enter the price with no commas (i.e. 40000).
The default SQL field type is LONGTXT.
I would like to display 40,000.
I coded the dollar sign ($) into the HTML so no problem there.
Need a code snippet to add to display the number with the appropriate seperator.
Tks,
John
The default SQL field type is LONGTXT.
I would like to display 40,000.
I coded the dollar sign ($) into the HTML so no problem there.
Need a code snippet to add to display the number with the appropriate seperator.
Tks,
John
Re: [pjd218] Format Price
By pjd218 - May 8, 2009
Never mind.
Got it! [font "Verdana"]$<?php echo number_format($record['price'] ,2) ?>
[font "Verdana"]Thanks.
Got it! [font "Verdana"]$<?php echo number_format($record['price'] ,2) ?>
[font "Verdana"]Thanks.