$yangi_maqola= mysql_query("SELECT * FROM `library_texts` WHERE `premod` = '1' ORDER BY `time` DESC LIMIT 15");
2.
while($yangi= mysql_fetch_assoc($yangi_maqola)){
3.
$matn= mb_substr($yangi['text'],0,97);
4.
$bolimi= mysql_fetch_assoc( mysql_query("SELECT * FROM `library_cats` WHERE `id` = '".$yangi['cat_id']."' "));
5.
$izohi= mysql_result( mysql_query("SELECT COUNT(*) FROM `cms_library_comments` WHERE `sub_id` = '".$yangi['id']."' "),0);
6.
echo'
7.
  <div class="list2">
8.
      <b>
9.
        <a href="/library/index.php?id='.$yangi['id'].'">
10.
          '.$yangi['name'].'
11.
        </a>
12.
      </b>
13.
      <span style="font-size:xx-small">['.functions::display_date($yangi['time']).']</span>
14.
      <br>'.$matn.'...
15.
      <br><span style="font-size:xx-small">[<a href="/library/index.php?id='.$bolimi['id'].'">'.$bolimi['name'].'</a>]</span>
16.
      <span style="float:right;font-size:xx-small">
17.
        <a href="/library/index.php?act=comments&id='.$yangi['id'].'">
18.
          <font color="red">Izohlar</font>
19.
        </a> ['.$izohi.']<br />
20.
        O\'qildi: '.$yangi['count_views'].'
21.
       </span>
22.
  </div>
23.
  ';
24.
}