HELP. raise the value of "number" in each feild

[Stretch]

What i want to do is raise the value of "number" in each feild when the script is called in a browser or chron job

 

this doesnt seem to work, in a noob. any help please?

 

<?

#connection

 

$sql="select `number`, `id` from table ORDER BY `id` DESC ";

$res = mysql_query($sql) or die(mysql_error());

while ($line = mysql_fetch_array($res));

{

$turns = $line['turns'];

$id = $line['id'];

 

echo $id . '-' . $turns;

}

?>

 

 

 

[AndyB]

Do you mean you want to increment the value of the field named number in every row of the table?

[Stretch]

yes, its for a turn based game...

 

i just want, like 100 turns added to the users account every time the script is called.

 

 

[fenway]

Like UPDATE whateverTable set column = column + 100 WHERE ...?