$query=mysql_query("SELECT MAX(id) as maxid FROM `accounts` LIMIT 1");
$row = mysql_fetch_assoc($query);
$id = $row['maxid'];

$query = "SELECT * FROM `accounts`";
$result=mysql_query($query);
while ($row=mysql_fetch_assoc($result)) {

$energy = $row['energy'];
$maxenergy = $row['maxenergy'];

}
for($i=1; $i<="$id"; $i++) {
$query = "SELECT * FROM `accounts` WHERE (id) = '".$id."'";
$result=mysql_query($query);
$addenergy = (0.08 * $maxenergy);
$energy = ($addenergy + $energy);

if($energy > $maxenergy) {
$energy = $maxenergy;
}
$query = "UPDATE `account` SET (energy) = '".$energy."' WHERE (id) = '".$id."'";
$result = mysql_query($query);
echo" The energy script worked!";
}

$energy = ($addenergy += $energy);

$result = mysql_query($query) or die(mysql_error());