[RESOLVED] number_format issue (yes I have searched)

[hypernol]

I am sorry, I know you guys hate when someone starts a new thread.

I have searched the forums and can't seem to find the answer. It is probably out there, but I just couldn't find it.

When I use the following code I get 50000000.00 while I am trying to get 50,000,000.00

//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";
}

I have also tried

//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";
}

Which produces 5000000000

If anyone could tell me what I am doing wrong it would be greatly appreciated..

[laserlight]

The first one (number_format($number, 2, '.', ',')) works for me. Are you sure you used it correctly?

[hypernol]

Well, the code is there. You tell me, hehe..

I have no idea, I think I used it correctly.

the . $member['bank'] is set to provide the number, now how do I get number_format to turn that number into a number with commas?

[laserlight]

What output do you get when you run this script?

<?php

$number = 50000000;

echo number_format($number, 2, '.', ',');

[hypernol]

I know how that works. If the number was just 50000000 then it would be easy. But the number is db generated through $member['bank']. So how do I get $member['bank'] to show as a comma separated value?

[laserlight]

What is the value of $member['bank']?

[hypernol]

That is the problem, it varies depending on each player. The value of $member['bank'] is what ever that player has in the bank. So, how do I get the variable value to format into a comma separated value?

[laserlight]

Um, then shouldn't you be using number_format($member['bank'], 2, '.', ',')?

[hypernol]

You are sooooooooo awesome. I had actually tried something close to that

$member[number_format('bank',0,",")] that doesn't work though..hehe.

Thank you the

number_format($member['bank'],2, '.', ',') worked great!!

I actually refined it to number_format($member['bank'],0, '.', ',') which produced the desired numeric value of 500,000,000.

[laserlight]

No problem 🙂
Remember to mark this thread as resolved (if it is) using the thread tools.

[hypernol]

It has been resolved.. 😃

[laserlight]

hypernol wrote:

But, now when I try to put the $ in so that it ends up as $500,0000,000

That does not make sense. It should be a simple:

echo '$' . number_format($member['bank'], 0, '.', ',');

[hypernol]

hey laser (or anyone else).

How would I get the following to output with number_format. I have tried in so many different ways, and can not figure it out.

<?=$player->cash?>

This calls the amount of cash in the players bank. Trying to do it the same way as the other script produces errors.

Simply trying to add the commas again.