Mana, oddiygina kodku: [code=php] $total = mysql_result(mysql

3339

Yangi formatda davom etish uchun: https://uzfor.net/view.php?act=post&id=55097

Postga havola

Aly_Ilamanow [204] [off]

Mana, oddiygina kodku:

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

$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>'; }