Updating multiple users?

dr_overload

I use this code to update a user's score.

<?php
mysql_connect("", "", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());

$data = mysql_query("SELECT * FROM table1 WHERE username='$username'")
or die(mysql_error());

while($info = mysql_fetch_array( $data ))
if ( $info['match_score_game1h'].$info['match_score_game1a'] == $info['game1h'].$info['game1a'] ) {

$result = mysql_query("UPDATE table1 SET game1='4' WHERE username='$username'" );

The $username is taken from login, however this means to update the whole database I have to input everyone's username into a login field one by one.

Is there a way to update all users in one go?

Just dropping the WHERE username = $username does not work, as all the users are updated with first user's score.

Thanks

Jon

konrad

Try this query:

UPDATE table1 SET game1='4' WHERE CONCAT(match_score_game1h, match_score_game1a) = CONCAT(game1h, game1a);

scrypted

Try something like this. It will select everything from table1 (which could be a bad idea depending on how many fields are in that table. Generally you only want to pull the data you need from the table.)

After all the needed data has been selected php will loop through each row that was pulled from the database. If your 'IF' statement returns true, then php will run an sql query and update the database row for whichever username it's currently processing.

<?
$res=mysql_query("SELECT * FROM table1");

while($row=mysql_fetch_assoc($res)) { extract($row);

if ($match_score_game1h.$match_score_game1a == $game1h.$game1a ) {

mysql_query("UPDATE table1 SET game1='4' WHERE username='$username'");

}unset($res, row);

?>

Before you run this script make sure username is the key column for table1. This willl not help you if you allows more than one user to have the same name. When performing an update like this you should always use the primary key in your WHERE clause.