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

$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `paper` WHERE `hide` != '1' AND `type` = 'a' AND `refid` = '1'"), 0);
if ($total) {
    $req = mysql_query("SELECT * FROM `paper` WHERE `hide` != '1' AND `type` = 'a' AND `refid` = '1' ORDER BY $order LIMIT 3");

    while ($res = mysql_fetch_array($req)) {
        echo $i % 2 ? '<div class="list2">' : '<div class="list1">';
        if (file_exists(('../files/paper/' . $res['id'] . '_preview.jpg')))
        echo '<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr><td align="left" valign="top">' . '<img src="../files/paper/' . $res['id'] . '_preview.jpg" align="left" hspace="6" vspace="6" alt="photo" /><p><h3>' . $res['name'] . '</h3>' . '&#160;(' . functions::display_date($res['time']) . ')</small></div></p>';
    
    } 
}