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

Oewgo, Поздно, так написал....

$req_lib = mysql_query("SELECT * FROM `lib` WHERE `type`='bk' ORDER BY `time` DESC LIMIT 5");
$i = 0;
while ($lib = mysql_fetch_assoc($req_lib)) {
    $komm = mysql_num_rows(mysql_query("select `id` from `lib` where type = 'komm' and refid = '" . $lib['id'] . "'"));
    echo '<div class="menu"><img src = "' . $set['homeurl'] . '/library/img/lib.png" alt = ""/>&nbsp;'
        . '<a href="' . $set['homeurl'] . '/library/index.php?id=' . $lib['id'] . '">' . $lib['name'] . '</a></div>'
        . '<div class="menu">Просмотров:&nbsp;<span class="label label-success">' . $lib['count'] . '</span>'
        . '&nbsp;|&nbsp;<a href="' . $set['homeurl'] . '/library/index.php?act=komm&amp;id=' . $lib['id'] . '">Комментарии</a>'
        . '&nbsp;<span class="label label-success">' . $komm . '</span>';
    echo '<div class="sub">Автор:&nbsp;<span class="label label-success">' . $lib['avtor'] . '</span></div></div>';
    //echo '<pre>';
    //print_r($lib);
    //echo '</pre>';
    ++$i;
}