Код:
$z_rev = mysql_query("SELECT * FROM `recenzies`");
$z_dis = mysql_query("SELECT * FROM `discographies`");
while ($dis = mysql_fetch_array($z_dis)){
$rev = mysql_fetch_array($z_rev);
if ($dis['id'] == $rev['album']) {
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `recenzies` WHERE `album` = '".$dis['id']."'"), 0);
$rating = ($rev['rate'] + $rev['rate']) % $total;
$update = mysql_query("UPDATE `discographies` SET `rate`='$rating' WHERE `id` = '".$dis['id']."'");
}
if ($update) echo '<br />Обновлено!<br />';
}