Help: Change all users at once? [Answered]

[Magnie]

Please move this to The Webmaster Bat-Cave, I put this in the wrong section, sorry!

( I may figure this out on my own :P ) Note: This isn't very related to the adoptable script, I'm making a game that is using the adoptable script as a... template you might say to run the game.

Okay, I am trying to make it so a user gets 100 Cash every five minutes, I've got it so the script/file will run every five minutes, I just can't get all the users getting 100 Cash. Only one user at a time, I'm trying to take the "User list" and have that update the user accounts resources, but, that doesn't seem to be working. :/ Here is the code that is suppose to be updating the users' resources:

PHP Code:

$query = "SELECT * FROM ".$prefix."users";

$result = mysql_query($query);



//Loop out code

$i=0;

while ($i < $num2) {


$user=@mysql_result($result,$i,"username");

$cash=@mysql_result($result,$i,"cash");

$metal=@mysql_result($result,$i,"metal");

$power=@mysql_result($result,$i,"power");

$fuel=@mysql_result($result,$i,"fuel");



$cashs = $cash + 100;
$metals = $metal + 75;
$powers = $power + 25;
$fuels = $fuel + 50;

$query = "UPDATE ".$prefix."users SET cash='".$cashs."' WHERE username='".$user."'";

mysql_query($query);



$query = "UPDATE ".$prefix."users SET metal='".$metals."' WHERE username='".$user."'";

mysql_query($query);



$query = "UPDATE ".$prefix."users SET fuel='".$fuels."' WHERE username='".$user."'";

mysql_query($query);

$query = "UPDATE ".$prefix."users SET power='".$powers."' WHERE username='".$user."'";

mysql_query($query);



$i++;

} 


Any ideas? ( I know it says fuel, metal, power, and cash and that stuff, but as I said before, this is for a game that isn't related to adoptables. ;) )