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

народ как сделать чтоб новые рубрики были сверху

echo '<div class="phdr"><b>Газета</b></div>';
    $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `paper` WHERE `close` != '1' AND `type` = 'cat'"), 0);
    if ($total) {
        $req = mysql_query("SELECT * FROM `paper` WHERE `close` != '1' AND `type` = 'cat' LIMIT $start,$kmess");
        while ($res = mysql_fetch_array($req)) {
            echo ceil(ceil($i / 2) - ($i / 2)) == 0 ? '<div class="list1">' : '<div class="list2">';
            $vrp = $res['time'] + $sdvig * 3600;
            $vr1 = date("d.m.y", $vrp);
            $vr2 = date("H:i", $vrp);
            $colbk = mysql_result(mysql_query("SELECT COUNT(*) FROM `paper` WHERE `close` != '1' AND `type` = 'bk' AND `cid` = '" . $res['id'] . "'"), 0);
            echo '<a href="index.php?act=cat&amp;id=' . $res['id'] . '">' . $res['text'] . '</a> (' . $colbk . ')';
            if (!empty($res['soft']))
                echo '<div class="sub"><span class="gray">' . $res['soft'] . '</span></div>';
            echo '</div>';
            ++$i;
        } 
    } else {
        echo '<div class="menu"><p>Рубрики не созданы</p></div>';
    }