Kod · PHP
$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>'; }5 daqiqa 46 soniyadan keyin yozdi:
Kod · PHP
$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>'; }