Aly_Ilamanow
Mana, oddiygina kodku:
  1. $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush`='b' "), 0);
  2.  
  3. $req = mysql_query("SELECT * FROM `forum` WHERE `gornush` = 'b' ORDER BY `id` DESC LIMIT $start, $kmess");
  4. if (mysql_num_rows($req)) {
  5. $i = 0;
  6. while ($res = mysql_fetch_assoc($req)) {
  7.  
  8. $podf = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush` = 't' AND `bolum` = '".$res['id']."'"),0);
  9.  
  10. $mowzuk = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush` = 'm' AND `bolum` = '".$res['id']."'"),0);
  11.  
  12.  
  13.  
  14. echo '<div class="p_m"><img src="http://dostluk.ru/forum/bolum.png" width="48" height="48" alt="" /><a href="http://dostluk.ru/forum/index.php?act=bolum&id='.$res['id'].'">'.$res['ady'].' ('.$podf.' / '.$mowzuk.')</a>';
  15.  
  16. echo '</div>';
  17.  
  18. }
  19.  
  20. }
  21. else {
  22.  
  23. echo '<div class="menu">Bölümler ýok</div>'; }

5 daqiqa 46 soniyadan keyin yozdi:
  1. $total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush`='b' "), 0);
  2.  
  3. $req = mysql_query("SELECT * FROM `forum` WHERE `gornush` = 'b' ORDER BY `id` DESC LIMIT $start, $kmess");
  4. if (mysql_num_rows($req)) {
  5. $i = 0;
  6. while ($res = mysql_fetch_assoc($req)) {
  7.  
  8. $podf = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush` = 't' AND `bolum` = '".$res['id']."'"),0);
  9.  
  10. $mowzuk = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush` = 'm' AND `bolum` = '".$res['id']."'"),0);
  11.  
  12.  
  13.  
  14. echo '<div class="p_m"><img src="http://dostluk.ru/forum/'.$res['surat'].'" width="48" height="48" alt="" /><a href="http://dostluk.ru/forum/index.php?act=bolum&id='.$res['id'].'">'.$res['ady'].' ('.$podf.' / '.$mowzuk.')</a><br>
  15. <center>'.$res['barada'].'';
  16.  
  17. echo '</div>';
  18.  
  19. }
  20.  
  21. }
  22. else {
  23.  
  24. echo '<div class="menu">Bölümler ýok</div>'; }