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

fifa-in, Вот с рейтингом. Пожалуйста

$total_art = mysql_result(mysql_query("select count(*) from `ablogs` where `type` = 'ph'"), 0);
if ($total_art) {
    $req_art = mysql_query("select * from `ablogs` where `type` = 'ph' order by `time` desc limit 3");
    $i = 0;
    while ($res_art = mysql_fetch_assoc($req_art)) {
        $total_plus = mysql_result(mysql_query("select count(*) from `ablogs_vote` where `type` = '1' and`photo` = '" . $res_art['id'] . "';"), 0);
        $total_minus = mysql_result(mysql_query("select count(*) from `ablogs_vote` where `type` = '0' and`photo` = '" . $res_art['id'] . "';"), 0);
        $rating = $total_plus - $total_minus;
        echo $i % 2 ? '<div class="list1">' : '<div class="list2">';
        echo '<img src="../articles/img/code.png" />&nbsp;<b><a href="../articles/?act=view&amp;id=' . $res_art['id'] . '">' . $res_art['name'] . '</a></b><br/>';
        echo htmlentities(mb_substr(bbcode::notags(ablogs::image_tag_del($res_art['text'])), 0, 150), ENT_QUOTES, 'UTF-8') . '... <a href="../articles/?act=view&amp;id=' . $res_art['id'] . '">Далее</a><br>' .
    '<small><span class="gray">Рейтинг: <b>' . $rating . '</b>&nbsp;(За:&nbsp;' . $total_plus . '&nbsp;|&nbsp;Против:&nbsp;' . $total_minus . ')</span></small>' .
'</div>';
        $i++;
    }
}