<?php
$query="SELECT id, title , description, last_updated FROM cms_news ORDER BY id DESC LIMIT 3";
$count=firesql("$query",'num');
if($count>=3)
{  
	?>
     <h4>News/Announcements</h4>    
    <?php 
	$newsrows=firesql("$query",'res');
	$i=1;
	while($newsres=mysqli_fetch_assoc($newsrows))
	{
		extract($newsres);
		$theclass="slider-cnt c".$i;	
	?>
        <div class="<?php echo $theclass ?>">
            <h6><?php echo $title ?></h6>
             <?php $disp= strip_tags($description) ?>
            <p><?php echo  substr($disp,0,95) ?></p>
        </div>
	<?php
	$i++;
	}?>    
	<div class="slider-cnt c4">        
	<a href="news-and-announcements.php" class="bmore">Read More</a>        
	</div>
	</div><div class="clear"></div>
    <?php
}
else
{
	switch ($count) 
	{		
		case "1":
		$newsrows=firesql("$query",'res');
		?>
		<h4>News/Announcements</h4>    
		<?php
		 $newsres=mysqli_fetch_assoc($newsrows);
		 extract($newsres);
		 ?>
		<div class="slider-cnt c1">
            <h6><?php echo $title ?></h6>
           <?php $disp= strip_tags($description) ?>
            <p><?php echo  substr($disp,0,95) ?></p>
		</div>
        <div class="slider-cnt c2">
      	 <h6>Puthupally Pally</h6>
       	 <p>Puthupally Pally.</p>
        </div>
        
        <div class="slider-cnt c3">
       	<h6>Puthupally Pally</h6>
        <p>Puthupally Pally.</p>
        </div>
        <div class="slider-cnt c4">        
        <a href="news-and-announcements.php" class="bmore">Read more</a>        
        </div>
        </div><div class="clear"></div>
        <?php		
		break;
		case "2":
		$newsrows=firesql("$query",'res');
		?>
		<h4>News/Announcements</h4>            
		<?php
		$newsrows=firesql("$query",'res');
		$i=1;
		while($newsres=mysqli_fetch_assoc($newsrows))
		{
		extract($newsres);
		$theclass="slider-cnt c".$i;	
		?>
		<div class="<?php echo $theclass ?>">
            <?php $disp= strip_tags($description) ?>
            <p><?php echo  substr($disp,0,95) ?></p>
		</div>
		<?php
		$i++;
		}?>
        <div class="slider-cnt c3">
       	<h6>Puthupally Pally</h6>
        <p>Puthupally Pally.</p>
        </div>
        <div class="slider-cnt c4">        
        <a href="news-and-announcements.php" class="bmore">Read more</a>        
        </div>
        </div><div class="clear"></div>
		<?php		 	
		break;
		default:
		?>
        <h4>News/Announcements</h4>      
        <div class="slider-cnt c1">
        <h6>Puthupally Pally</h6>
        <p>Puthupally Pally.</p>
        </div>
        
        <div class="slider-cnt c2">
      	 <h6>Puthupally Pally</h6>
       	 <p>Puthupally Pally.</p>
        </div>
        
        <div class="slider-cnt c3">
       	<h6>Puthupally Pally</h6>
        <p>Puthupally Pally.</p>
        </div>        
        <div class="slider-cnt c4">        
        <a href="news-and-announcements.php" class="bmore">Read more</a>        
        </div>
        </div><div class="clear"></div>
        <?php
		
	}
}
?>