number_format() and printing

hypernol

I am having trouble making the number_format() to work correctly. I have tried it several ways, but keep coming up with the same results.

This is what I have right now..

<?php
//Select all members ordered by level (highest first, members table also doubles as rankings table)
$query = $db->execute("select `id`, `username`, `bank` from `players` order by `bank` desc limit 1000");

while($member = $query->fetchrow())
{
	echo "<tr>\n";
	echo "<td><a href=\"profile.php?id=" . $member['username'] . "\">";
	echo ($member['username'] == $player->username)?"<b>":"";
	echo $member['username'];
	echo ($member['username'] == $player->username)?"</b>":"";
	echo "</a></td>\n";
	echo "<td>$" . $member ['bank'].number_format($number)."</td>\n";
	echo "</tr>\n";
}
?>

Expected outcome is = $500,000,000

Actual outcome is = 500000000

When I do it as I did below...

<?php
//Select all members ordered by level (highest first, members table also doubles as rankings table)
$query = $db->execute("select `id`, `username`, `bank` from `players` order by `bank` desc limit 1000");

while($member = $query->fetchrow())
{
	echo "<tr>\n";
	echo "<td><a href=\"profile.php?id=" . $member['username'] . "\">";
	echo ($member['username'] == $player->username)?"<b>":"";
	echo $member['username'];
	echo ($member['username'] == $player->username)?"</b>":"";
	echo "</a></td>\n";
	echo "<td>" . $member ['bank'].number_format($number, 2, '.', ',')."</td>\n";
	echo "</tr>\n";
}
?>

Again, expected outcome is $500,000,000

Actual outcome is 500000000.00

If someone can give me an idea of how I can get this to work correctly I would greatly appreciate it.

Brutal

First I would try this as it would rip of the decimals, that you don't seem to want!

echo "<td>" . $member ['bank'].number_format($number, 0, '.', ',')."</td>\n";

Other than that it look alrigt to me. I'm don't have access to anything to try it on, but it looks alright. What does $member['bank'] contain? 500000000,0 or does it contain a string "$500000000" ? If it is the later I would suspect that it might confuse the number_format() function.

There is also a function called money_format(), that might be interesting to look into.

http://se.php.net/manual/en/function.money-format.php

hypernol

Brutel,

We figured it out yesterday. The actual string should be

echo "<td>"$. number_function($member ['bank'], '0', '.', ',')."</td>\n;"

hypernol

Now I am just having a problem doing the same thing to this.

<?=$player->cash?>

I have tried it several different ways and found none that work.

Do you happen to know how i can get the number function to work on this one?

laserlight

Moderation note: this thread was split from the resurrected thread Formatting strings?.

hypernol wrote:
Now I am just having a problem doing the same thing to this.

That line of code is short hand for:

<?php echo $player->cash; ?>

As such, applying number_format() would make it:

<?php echo number_format($player->cash); ?>

hypernol

Laser, I think I love you...lol

That worked beautifully!!

hypernol

OK, another one...lol

How would I add it to this while keeping the interval?

<?=intval($player->bank * 0.10)?>/PHP]

laserlight

What have you tried? I cannot keep spoonfeeding you forever.

nrg_alpha

hypernol, at the rate you're going, you might as well ask people to code everything for you.
Take some time and initiative to learn to trouble shoot things. Being less dependant on others and more dependant on yourself is one the better things you can do for yourself.

Give a man a fish, he can eat for a day.. teach a man to fish, he can eat for a lifetime.

Right now, you're constantly asking people to give you fish.. why not learn how to fish for yourself?

hypernol

Thank you all for the help you have provided. I apologize for asking.

laserlight

hypernol wrote:
I apologize for asking.

It is not the asking that you should apologize for, but failing to try and/or post your attempt. You should already know how number_format() works, and after reading my post #5 where I talk about what the syntax is a short hand for you should have been able to deduce the solution when the syntax is used again.

hypernol

Well thank you anyway. It was the number_function + intval together that I was having a problem with. But, no worries. I will figure it out. Thank you again for the help you so kindly provided me.