Updating every row

[marcus]

I'm making a game, and I want to update ever users points count and add 20,000 points to it.

[code]
<?php
require('../connect.php');
$sql = "SELECT * FROM `users`";
$res = mysql_query($sql);
$row = mysql_fetch_assoc($res);
$points = $row[points];
echo $points;
?>
[/code]

When I echo $points it only shows the first row. Would it just be simply using a while statement to do this or could I just update like this?

[Psycho]

<?php
require('../connect.php');
$sql = "SELECT * FROM `users`";
$res = mysql_query($sql);
while ($row = mysql_fetch_assoc($res)) {
    $points = $row[points];
    echo $row[userID]."<br>";
    echo "  Old Points: ".$points;
    echo "<br>  New Points: ".($points+20000);
    $sql = "UPDATE `users` SET points = ".($points+20000)." WHERE userID = ".$row[userID];
    mysql_query($sql);
}
?>

[ToonMariner]

or just

$sql = "UPDATE `users` SET `points` = `points` + 20000";
    mysql_query($sql);

the above may fail as you may be restricted to teh number of queries you can run in one script - this query will do the lot all at once.

To show them all you need
[code]
<?php
require('../connect.php');
$sql = "SELECT * FROM `users`";
$res = mysql_query($sql);
while ($row = mysql_fetch_assoc($res))
{
echo $row[points] . "<br />";
}
?>
[/code]

That while statement is a prime candidate for putting all that info into a table - that way you can see the username etc. etc. (you will have to echo out each field in teh table - not just teh points).