<?php 
include_once("session.php");
include_once("settings.php");
include_once("functions.php");
?> 
<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>Career LIST</legend>
				<table width="100%" border="0" cellspacing="2" cellpadding="0">
				<?php
					if($msg!=""){ ?>
					<tr valign="middle" class="general"> 
						<td height="26" colspan="4"> 
							<?=$msg;?>
						</td>
					</tr>
				<?php } ?>
					<tr valign="middle" class="general"> 
						<td width="25%" height="26">Job Title</td>
						<td width="28%" height="26" >Name</td>
						<td width="27%" >Address</td>
						<td width="10%" >Resume</td>
						<td width="10%" align="center" >Action</td>
					</tr>
				<?php
					$query	=	"select * from `tblCareer` order by createdOn DESC";
					$result	=	mysql_query($query) or die (mysql_error());
					while($row=mysql_fetch_assoc($result)){
				?>
					<tr valign="middle" class="generaltxt"> 
						<td height="24"><?php echo $row["jobTitle"]; ?></td>
						<td><?php echo $row["name"]."<br>".$row["email"]."<br>".$row["phone"]; ?></td>
						<td><?php echo $row["address"]."<br>".$row["city"]; ?></td>
						<td><a style='color:#000;' href="download.php?filename=<?php echo $row['resume'];?>">View</a></td>
						<td align="center"><a  href="<?php echo "career_list.php?id=".$row['id']."&action=deletecareer"; ?>" onClick="return confirm('Are you sure you want to delete this Application')" class="action1">Delete</a> 
						</td>
					</tr>
				<?php } ?>
				</table>
			</fieldset>
		</td>
	</tr>
</table>