Нарзулло, <?php
$yangi_maqola = mysql_query("SELECT * FROM `library_texts` WHERE `premod` = '1' ORDER BY `time` DESC LIMIT 4");
while ($yangi = mysql_fetch_assoc($yangi_maqola)) {
$matn = mb_substr($yangi['text'], 0, 97);
$bolimi = mysql_fetch_assoc(mysql_query("SELECT * FROM `library_cats` WHERE `id` = '".$yangi['cat_id']."' "));
$izohi = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_library_comments` WHERE `sub_id` = '".$yangi['id']."' "), 0);
$lng_lib = core::load_lng('library');
echo '
<div class="list2">
<b>
<a href="/library/index.php?id='.$yangi['id'].'">
'.$yangi['name'].'
</a>
</b>
<span style="font-size:xx-small">['.functions::display_date($yangi['time']).']</span>
<br>'.$matn.'...
<br><span style="font-size:xx-small">[<a href="/library/index.php?id='.$bolimi['id'].'">'.$bolimi['name'].'</a>]</span>
<span style="
float:right;font-size:xx-small">
O'qildi:
'. $lng_lib=$yangi['count_views']+$yangi['count_views'].' </span>
</div>
';
}
?>
2161dan so'ng qo'shdi...
mr_xhr, Dababit vso