Как мога да направя това?

Unde3d

Registered
Как мога да направя когато са 0 коментарите на дадена обява/песен да показва Няма коментари а като има да показва броят?
 
ако имаш примерно таблица pesni и в нея поле komentari си правиш една заявка

$query = mysql_query("SELECT komentari FROM pesni ");

и правиш проверка

$broi = mysql_num_rows($query);

if($broi <= 0){

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

}

elseif($broi > 0){

echo"$broi";

}
 
Дава ми ерор ето кода на index.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>
		<td style="text-align: right; font: 11px verdana; color: #333;"><a href="view.php?id='.$row[id].'" style="font: 11px verdana; color: #333;">Коментари: (няма коментари)</a></td>
	</tr>
</table>
</div> ';
                        }
						$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');?>
Ерора е Parse error: syntax error, unexpected $end in E:\VertrigoServ\www\index.php on line 103
 
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
Горе