Advice please

[Phpfr3ak]

Hi, basically i have data in my database i want to represent as cash, i currently put the dollar sign infront of each echo which is fine, but how would i go about adding , to the php code itself as you cannot do this from the sql database..

[johnsmith153]

do you mean echo "$" . $value; ?

[BlueSkyIS]

echo '$'.$value;
echo "\$$value";

[Pikachu2000]

It could be done directly in the query, if you want to do it that way. It may end up being less code if you have a lot of values to display.

 

SELECT CONCAT('$', FORMAT(`field`, 2)) AS alias FROM `table` WHERE `some_field` = 'some_parameter'

 

EDIT: There may be other considerations, such as precision and rounding, no matter which method you use.

[Phpfr3ak]

Sorry i wasn;t very clear, what i actually meant was numbers that i currently want shown as money form are shown as say 345678 where as id like them to be shown as 345,678

[litebearer]

have you looked at http://php.net/manual/en/function.money-format.php

[Phpfr3ak]

Thanks for that i've done the following, only problem is it shows the noto as say 239,952,380.00 is there a way to remove the . as its not needed in the manner im using it and it looks out of place, thanks.

 

<?php echo number_format($data2['noto'], 2, '.', ','); ?></strong>xp)</span></td>

[gevensen]

if i remember right you either make the decila 0 or NULL in number format as below

 

<?php echo number_format($data2['noto'], 2, '.', ','); ?>

<?php echo number_format($data2['noto'], 0, '.', ','); ?>

<?php echo number_format($data2['noto'], 0, '', ','); ?>