Проблем с извеждане на коментари?

U

Unde3d

Registered
Защо става така?
Ето адреса http://90.154.191.48/index.php
Имам предвид на 1вата обява най долу има коментари и категория а на 2рата няма защо така ето кода на страницата
Код: 
<?php include('header.php'); ?> 
<?php include('menu_left.php');?>    
            <div id="menu_center"> 
          
            <div class="center_menu_box"> 
                    <div class="box_head"><span class="head_text"><center>Новини</center></span></div> 
                        <div class="text_menu">         ssa      </div> 
                    <div class="menu_bottom"> </div> 
                </div><br /> 
            <div class="center_menu_box"> 
                    <div class="box_head"><span class="head_text"><center>Tоп3 потребители добавили най-много обяви</center></span></div> 
                        <div class="text_menu"> 
                  <table width="100%" border="0"> 
                  <tr> 
                  <td><td> 
                     <center> 
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span> 
                        <br /> 
                        <span style='font: 11px arial;'>Добавени обяви: 67</span> 
                     </div> 
</center> 
                  </td><td> 
                     <center> 
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span> 
                        <br /> 
                        <span style='font: 11px arial;'>Добавени обяви: 67</span> 
                     </div> 
</center> 
                  </td><td> 
                     <center> 
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span> 
                        <br /> 
                        <span style='font: 11px arial;'>Добавени обяви: 67</span> 
                     </div> 
</center> 
                  </td>                  </tr> 
                  </table> 
                        </div> 
                    <div class="menu_bottom"> </div> 
                </div> 
          
            <br /> 
             
            <center><div><form action="" method="POST"> 
               <input name="duma" type="text" id="surchinput" /><input type="submit" name="tursi" value="Търси" class="searchBtn"> 
            </form></div></center> 
                         
             
            <br /> 

                      
                <div class="center_menu_box"> 
                    <div class="box_head"><span class="head_text"><center>Последни обяви</center></span></div> 
                        <div class="text_menu">       

                        <? 
                        $runq = mysql_query("SELECT * FROM `obqvi` WHERE accepted='yes' ORDER BY id DESC LIMIT 0, 15") or die (mysql_error()); 
                        while($row = mysql_fetch_assoc($runq)) { 
                        echo '<div class="title_jokes"> 
   <div class="t_jokes_text"><a href="view.php?id='.$row[id].'">'.$row[obqva].'</a></div> 
</div>'; 
echo '<div class="view_jokes_text"> 
<div class="view_jokes_padding">'.$row[url].'</div> 
</div> '; 
                        } 
                                          $runq = mysql_query("SELECT * FROM `cats` ") or die (mysql_error()); 
                        while($row = mysql_fetch_assoc($runq)) { 
echo ' 
<div class="jokes_info"> 
<table width="525px" border="0" cellspacing="0"> 
   <tr> 
      <td style="text-align: left; font: 11px verdana; color: #333;">Категория: <a href="category.php?id='.$row[cat_id].'" style="font: 11px verdana; color: #333;">'.$row[title].'</td>  '; 
                        } 
                  $query = mysql_query("SELECT obqva_id FROM comment "); 
                  $broi = mysql_num_rows($query); 

if($broi <= 0){ 

echo"няма коментари"; 

} 

elseif($broi > 0){ 

echo"<td style='text-align: right; font: 11px verdana; color: #333;'><a href='view.php?id='.$row[id].'' style='font: 11px verdana; color: #333;'>Коментари: $broi</a></td> 
   </tr> 
</table> 
</div>"; 
}
                        ?> 

                        </div> 
                    <div class="menu_bottom"> </div> 
                </div> 
          
            </div> 
           
<?php include('menu_right.php');?>          
<?php include('footer.php');?>
 
Заявката, която ти брои коментарите трябва да е в цикъла, а не извън него :lol:
 
Код: 
 <?php include('header.php'); ?>
<?php include('menu_left.php');?>   
            <div id="menu_center">
         
            <div class="center_menu_box">
                    <div class="box_head"><span class="head_text"><center>Новини</center></span></div>
                        <div class="text_menu">         ssa      </div>
                    <div class="menu_bottom"> </div>
                </div><br />
            <div class="center_menu_box">
                    <div class="box_head"><span class="head_text"><center>Tоп3 потребители добавили най-много обяви</center></span></div>
                        <div class="text_menu">
                  <table width="100%" border="0">
                  <tr>
                  <td><td>
                     <center>
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span>
                        <br />
                        <span style='font: 11px arial;'>Добавени обяви: 67</span>
                     </div>
</center>
                  </td><td>
                     <center>
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span>
                        <br />
                        <span style='font: 11px arial;'>Добавени обяви: 67</span>
                     </div>
</center>
                  </td><td>
                     <center>
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span>
                        <br />
                        <span style='font: 11px arial;'>Добавени обяви: 67</span>
                     </div>
</center>
                  </td>                  </tr>
                  </table>
                        </div>
                    <div class="menu_bottom"> </div>
                </div>
         
            <br />
            
            <center><div><form action="" method="POST">
               <input name="duma" type="text" id="surchinput" /><input type="submit" name="tursi" value="Търси" class="searchBtn">
            </form></div></center>
                         
            
            <br />

                     
                <div class="center_menu_box">
                    <div class="box_head"><span class="head_text"><center>Последни обяви</center></span></div>
                        <div class="text_menu">       

                        <?
                        $runq = mysql_query("SELECT * FROM `obqvi` WHERE accepted='yes' ORDER BY id DESC LIMIT 0, 15") or die (mysql_error());
                        while($row = mysql_fetch_assoc($runq)) {
                        echo '<div class="title_jokes">
   <div class="t_jokes_text"><a href="view.php?id='.$row[id].'">'.$row[obqva].'</a></div>
</div>';
echo '<div class="view_jokes_text">
<div class="view_jokes_padding">'.$row[url].'</div>
</div> ';
                        }
                                          $runq = mysql_query("SELECT * FROM `cats` ") or die (mysql_error());
                        while($row = mysql_fetch_assoc($runq)) {
echo '
<div class="jokes_info">
<table width="525px" border="0" cellspacing="0">
   <tr>
      <td style="text-align: left; font: 11px verdana; color: #333;">Категория: <a href="category.php?id='.$row[cat_id].'" style="font: 11px verdana; color: #333;">'.$row[title].'</td>  ';
                  
                  $query = mysql_query("SELECT obqva_id FROM comment ");
                  $broi = mysql_num_rows($query);

if($broi <= 0){

echo"няма коментари";

}

elseif($broi > 0){

echo"<td style='text-align: right; font: 11px verdana; color: #333;'><a href='view.php?id='.$row[id].'' style='font: 11px verdana; color: #333;'>Коментари: $broi</a></td>
   </tr>
</table>
</div>";
}
      }
                        ?>

                        </div>
                    <div class="menu_bottom"> </div>
                </div>
         
            </div>
          
<?php include('menu_right.php');?>         
<?php include('footer.php');?>


Я виж така
 
Пробвай така:

Код: 
 <?php include('header.php'); ?>
<?php include('menu_left.php');?>   
            <div id="menu_center">
         
            <div class="center_menu_box">
                    <div class="box_head"><span class="head_text"><center>Новини</center></span></div>
                        <div class="text_menu">         ssa      </div>
                    <div class="menu_bottom"> </div>
                </div><br />
            <div class="center_menu_box">
                    <div class="box_head"><span class="head_text"><center>Tоп3 потребители добавили най-много обяви</center></span></div>
                        <div class="text_menu">
                  <table width="100%" border="0">
                  <tr>
                  <td><td>
                     <center>
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span>
                        <br />
                        <span style='font: 11px arial;'>Добавени обяви: 67</span>
                     </div>
</center>
                  </td><td>
                     <center>
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span>
                        <br />
                        <span style='font: 11px arial;'>Добавени обяви: 67</span>
                     </div>
</center>
                  </td><td>
                     <center>
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span>
                        <br />
                        <span style='font: 11px arial;'>Добавени обяви: 67</span>
                     </div>
</center>
                  </td>                  </tr>
                  </table>
                        </div>
                    <div class="menu_bottom"> </div>
                </div>
         
            <br />
            
            <center><div><form action="" method="POST">
               <input name="duma" type="text" id="surchinput" /><input type="submit" name="tursi" value="Търси" class="searchBtn">
            </form></div></center>
                         
            
            <br />

                     
                <div class="center_menu_box">
                    <div class="box_head"><span class="head_text"><center>Последни обяви</center></span></div>
                        <div class="text_menu">       

                        <?
                        $runq = mysql_query("SELECT * FROM `obqvi` WHERE accepted='yes' ORDER BY id DESC LIMIT 0, 15") or die (mysql_error());
                        while($row = mysql_fetch_assoc($runq)) {
                        echo '<div class="title_jokes">
   <div class="t_jokes_text"><a href="view.php?id='.$row[id].'">'.$row[obqva].'</a></div>
</div>';
echo '<div class="view_jokes_text">
<div class="view_jokes_padding">'.$row[url].'</div>
</div> ';
                        }
                                          $runq = mysql_query("SELECT * FROM `cats` ") or die (mysql_error());
                        while($row = mysql_fetch_assoc($runq)) {
echo '
<div class="jokes_info">
<table width="525px" border="0" cellspacing="0">
   <tr>
      <td style="text-align: left; font: 11px verdana; color: #333;">Категория: <a href="category.php?id='.$row[cat_id].'" style="font: 11px verdana; color: #333;">'.$row[title].'</td>  ';
                       
                  $query = mysql_query("SELECT obqva_id FROM comment ");
                  $broi = mysql_num_rows($query);

if($broi <= 0){

echo"няма коментари";

}

elseif($broi > 0){

echo"<td style='text-align: right; font: 11px verdana; color: #333;'><a href='view.php?id='.$row[id].'' style='font: 11px verdana; color: #333;'>Коментари: $broi</a></td>
   </tr>
</table>
</div>";
}
 }
                        ?>

                        </div>
                    <div class="menu_bottom"> </div>
                </div>
         
            </div>
          
<?php include('menu_right.php');?>         
<?php include('footer.php');?>
 
Код: 
  <?php include('header.php'); ?>
<?php include('menu_left.php');?>   
            <div id="menu_center">
         
            <div class="center_menu_box">
                    <div class="box_head"><span class="head_text"><center>Новини</center></span></div>
                        <div class="text_menu">         ssa      </div>
                    <div class="menu_bottom"> </div>
                </div><br />
            <div class="center_menu_box">
                    <div class="box_head"><span class="head_text"><center>Tоп3 потребители добавили най-много обяви</center></span></div>
                        <div class="text_menu">
                  <table width="100%" border="0">
                  <tr>
                  <td><td>
                     <center>
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span>
                        <br />
                        <span style='font: 11px arial;'>Добавени обяви: 67</span>
                     </div>
</center>
                  </td><td>
                     <center>
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span>
                        <br />
                        <span style='font: 11px arial;'>Добавени обяви: 67</span>
                     </div>
</center>
                  </td><td>
                     <center>
                     <div style='background: url(img/profile.png) no-repeat; width: 135px; height: 169px; margin: 10px 5px -20px 5px; padding: 20px 0 0 0;' ><a href='/user:Styl3r'><img src='avatars/1.png' alt='Няма аватар' width='90px' height='90px' style='border: 1px solid #000;' border='0' /></a><br /><span class='slinks'><a href='user:Styl3r' >Styl3r</a></span>
                        <br />
                        <span style='font: 11px arial;'>Добавени обяви: 67</span>
                     </div>
</center>
                  </td>                  </tr>
                  </table>
                        </div>
                    <div class="menu_bottom"> </div>
                </div>
         
            <br />
            
            <center><div><form action="" method="POST">
               <input name="duma" type="text" id="surchinput" /><input type="submit" name="tursi" value="Търси" class="searchBtn">
            </form></div></center>
                         
            
            <br />

                     
                <div class="center_menu_box">
                    <div class="box_head"><span class="head_text"><center>Последни обяви</center></span></div>
                        <div class="text_menu">       

                        <?
                        $runq = mysql_query("SELECT * FROM `obqvi` WHERE accepted='yes' ORDER BY id DESC LIMIT 0, 15") or die (mysql_error());
                        while($row = mysql_fetch_assoc($runq)) {
                        echo '<div class="title_jokes">
   <div class="t_jokes_text"><a href="view.php?id='.$row[id].'">'.$row[obqva].'</a></div>
</div>';
echo '<div class="view_jokes_text">
<div class="view_jokes_padding">'.$row[url].'</div>
</div> ';
                        
                                          $runq = mysql_query("SELECT * FROM `cats` ") or die (mysql_error());
                        while($row = mysql_fetch_assoc($runq)) {
echo '
<div class="jokes_info">
<table width="525px" border="0" cellspacing="0">
   <tr>
      <td style="text-align: left; font: 11px verdana; color: #333;">Категория: <a href="category.php?id='.$row[cat_id].'" style="font: 11px verdana; color: #333;">'.$row[title].'</td>  ';
                       
                  $query = mysql_query("SELECT obqva_id FROM comment ");
                  $broi = mysql_num_rows($query);

if($broi <= 0){

echo"няма коментари";

}

elseif($broi > 0){

echo"<td style='text-align: right; font: 11px verdana; color: #333;'><a href='view.php?id='.$row[id].'' style='font: 11px verdana; color: #333;'>Коментари: $broi</a></td>
   </tr>
</table>
</div>";
}
 }
   }   ?>

                        </div>
                    <div class="menu_bottom"> </div>
                </div>
         
            </div>
          
<?php include('menu_right.php');?>         
<?php include('footer.php');?>
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе