$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.

}