<?php 
include_once("session.php");
include_once("settings.php");
include_once("functions.php");

if($_REQUEST['action']=='DeleteTestimonial')
{ 
    $sql="delete from tblTestimonial where Testimonial_Id  ='".$_REQUEST['id']."' ";
    mysql_query($sql) or die(mysql_error());
}
?> 
<LINK href="mel.css" type=text/css 
rel=stylesheet><LINK href="sdmenu.css" 
type=text/css rel=stylesheet>
<table width="94%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td>
        <fieldset>
        
      <legend>TESTIMONIAL LIST FORM</legend>
        
      <table width="100%" border="0" cellspacing="2" cellpadding="0">
        <?php
		  if($msg!=""){ ?>
        <tr valign="middle" class="general"> 
          <td height="26" colspan="4" align="center"> 
            <?=$msg;?>
          </td>
        </tr>
        <?php } ?>
        <tr valign="middle" class="general"> 
          <td height="26" colspan="4"><input type="button" name="btnadd" value="Add Testimonial" class="button" onclick="window.location.href='testimonial_add.php?mode=Add&page=addtestimonial'" style="width:150px" /></td>
        </tr>
        <tr valign="middle" class="general"> 
          <td width="22%" height="26">Comapny Name</td>
          <td width="23%" height="26" >Employee Name</td>
          <td width="40%" align="center" >Testimonial</td>
          <td width="15%" align="center" >Action</td>
        </tr>
        <?php
				$query="select * from `tblTestimonial`";
				$result=mysql_query($query);
				while($arrayCategory=mysql_fetch_assoc($result))
				{	  
		?>
        <tr valign="top" class="generaltxt"> 
          <td height="26"> 
            <?=$arrayCategory['Company_Name']?>
          </td>
          <td height="26"> 
            <?=$arrayCategory['Employee_Name']?>
          </td>
          <td align="center"> 
            <div align="justify"><? echo stripslashes($arrayCategory['Testimonial']);?> </div></td>
          <td align="center"><a href="testimonial_add.php?id=<?=$arrayCategory['Testimonial_Id']?>&mode=Edit&page=addtestimonial" class="action1"><strong>Edit</strong></a> 
            | <a href="testimonial_list.php?id=<?=$arrayCategory['Testimonial_Id']?>&action=DeleteTestimonial" onClick="return confirm('Are you sure you want to delete this  record?')" class="action1"><strong>Delete</strong></a></td>
        </tr>
        <?php } ?>
        <tr align="right" valign="middle" class="generaltxt"> 
          <td height="10" colspan="4">&nbsp;</td>
        </tr>
        <tr align="right" valign="middle" class="generaltxt"> 
          <td height="26" colspan="4"><input type="button" name="btnadd2" value="Add Testimonial" class="button" onclick="window.location.href='testimonial_add.php?mode=Add&page=addtestimonial'" style="width:150px" /></td>
        </tr>
      </table>
        </fieldset>
      </td>
  </tr>
</table>