$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush`='b' "), 0); $req = mysql_query("SELECT * FROM `forum` WHERE `gornush` = 'b' ORDER BY `id` DESC LIMIT $start, $kmess"); if (mysql_num_rows($req)) { $i = 0; while ($res = mysql_fetch_assoc($req)) { $podf = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush` = 't' AND `bolum` = '".$res['id']."'"),0); $mowzuk = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush` = 'm' AND `bolum` = '".$res['id']."'"),0); 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>'; echo '</div>'; } }else { echo '<div class="menu">Bölümler ýok</div>'; }
$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush`='b' "), 0); $req = mysql_query("SELECT * FROM `forum` WHERE `gornush` = 'b' ORDER BY `id` DESC LIMIT $start, $kmess"); if (mysql_num_rows($req)) { $i = 0; while ($res = mysql_fetch_assoc($req)) { $podf = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush` = 't' AND `bolum` = '".$res['id']."'"),0); $mowzuk = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `gornush` = 'm' AND `bolum` = '".$res['id']."'"),0); 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><center>'.$res['barada'].''; echo '</div>'; } }else { echo '<div class="menu">Bölümler ýok</div>'; }
« Mavzuga qaytish