Number format in echo statement of a row

[oceanwave]

Hi,

Items are being displayed after query of database as in the format (looping - rows):

echo "Price = $row[price]   ....

How do you use the number format function inside an echo statement referring to rows? I want to add commas to my price values in each row displayed.
12345 would change to 12,345, etc.

I've used the number format before, but never in a looping row echo statement.

[jatar_k]

echo 'Price = ',number_format($row['price']),'  ';

though you would have to add the extra parameters for the function

[edited by: jatar_k at 3:26 pm (utc) on Sep. 7, 2007]

[d40sithui]

try

<?

$decimal_places = 2;

echo "price ". number_format($row['price'], $decimal_places). "&nbsp;&nbsp;";

?>
careful though, number_format() rounds up numbers if you dont use the optional parameters.
also you can try money_format.

[us3.php.net...]
[us3.php.net...]

[mooger35]

Try this

echo "Price = ".number_format($row['price'],2)." &nbsp;&nbsp;....";

//edit: just a little late with the submit button.

[d40sithui]

lol and i thought i was late

[oceanwave]

Thank you everyone. Works fine now. Just out of curiosity....where did you find/learn the code for this?

[jatar_k]

pretty standard, you can mix functions into almost anywhere, make single lines of code be as confusing as possible

though it isn't always recommended as it becomes hard to follow at some point

you could do this

$mytexttoinsert = mysql_real_escape_string(strip_tags(trim($_POST['somevalue'])));

I have one somewhere with quite a few more than that but couldn't find it for an example

and the way to learn new functions, is to read the manual