Просмотр поста

Код:

$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 />';
                }