<?php 
include_once("session.php");
include_once("settings.php");
include_once("functions.php");
foreach ($_REQUEST as $key => $value){
	$$key = $value;
}
if($action == 'DeleteCertificate'){
	$sql	=	"SELECT * FROM `tblCertificate` where id = ".$id."";
	$result	=	mysql_query($sql) or die (mysql_error());
	$row	=	mysql_fetch_assoc($result);
	for($i=1;$i<=10;$i++){
		@unlink("../cat_images/certificates/".$row['pic'.$i]);
	}
	$sql1	=	"DELETE FROM `tblCertificate` WHERE `id` = ".$id." LIMIT 1";
	mysql_query($sql1) 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>CERTIFICATE LIST FORM</legend>
				<table width="100%" border="0" cellspacing="2" cellpadding="0">
				<?php	if($msg	!=	""){	?>
					<tr valign="middle" class="general"> 
						<td height="26" colspan="2" align="center"><?=$msg;?></td>
					</tr>
				<?php } ?>
					<tr valign="middle" class="general"> 
						<td height="26" colspan="2"><input type="button" name="btnadd22" value="Add Certificate" class="button" onclick="window.location.href='certificate_add.php?mode=Add&page=addCertificates'" style="width:150px" /></td>
					</tr>
					<tr valign="middle" class="general"> 
						<td width="70%" height="26">Certificate</td>
						<td width="30%" height="26" align="center" valign="middle" >Action</td>
					</tr>
					<?php
						$query	=	"select * from `tblCertificate` order by createdOn DESC";
						$result	=	mysql_query($query);
						while($arrayCategory=mysql_fetch_assoc($result)){	  
					?>
					<tr valign="middle" class="generaltxt"> 
						<td height="26">
							<?php echo $arrayCategory['heading'];	?>
						</td>
						<td align="center"><a href="certificate_add.php?id=<?=$arrayCategory['id']?>&mode=Edit&page=addCertificates" class="action1"><strong>Edit</strong></a> | <a href="certificate_list.php?id=<?=$arrayCategory['id']?>&action=DeleteCertificate" onClick="return confirm('Are you sure you want to delete')" class="action1"><strong>Delete</strong></a></td>
					</tr>
					<?php } ?>
					<tr align="right" valign="middle" class="generaltxt"> 
						<td height="10" colspan="2">&nbsp;</td>
					</tr>
					<tr align="right" valign="middle" class="generaltxt"> 
						<td height="26" colspan="3"><input type="button" name="btnadd2" value="Add Certificate" class="button" onclick="window.location.href='certificate_add.php?mode=Add&page=addCertificates'" style="width:150px" /></td>
					</tr>
				</table>
			</fieldset>
		</td>
	</tr>	
</table>