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

if($_REQUEST['action']=='deletejobs'){
$sql="DELETE from `tblJobs` where 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>JOBS 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"> 
            <?=$msg;?>
          </td>
        </tr>
        <?php } ?>
        <tr valign="middle" class="general"> 
          <td height="26" colspan="4"><input type="button" name="btnadd2" value="Add Jobs" class="button" onclick="window.location.href='jobs_add.php?mode=Add&page=addcareer'" style="width:150px" /></td>
        </tr>
        <tr valign="middle" class="general"> 
          <td width="27%" height="26">Job Id</td>
          <td width="42%" height="26" >Job Title</td>
          <td width="18%" >Experience</td>
          <td width="13%" align="center" >Action</td>
        </tr>
        <?php
					$query="select * from `tblJobs` order by id";
								$result=mysql_query($query) or die (mysql_error());
								while($row=mysql_fetch_assoc($result))
								{
								$id=$row["id"];
								$job_id=$row["job_id"];
								$job_title=$row["job_title"];   
								$experience=$row["experience"]; 
				?>
        <tr valign="middle" class="generaltxt"> 
          <td height="24"> 
            <?=$job_id?>
          </td>
          <td height="24"><strong><? echo "$job_title"; ?></strong></td>
          <td><? echo "$experience"; ?></td>
          <td align="center"><a href="jobs_add.php?id=<?=$row['id']?>&mode=Edit&page=addcareer" class="action1"><strong>Edit</strong></a> 
            | <a  href="<?php echo "jobs_list.php?id=$id&action=deletejobs"; ?>" onClick="return confirm('Are you sure you want to delete this jobs')" class="action1">Delete</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="btnadd" value="Add Jobs" class="button" onclick="window.location.href='jobs_add.php?mode=Add&page=addcareer'" style="width:150px" /></td>
        </tr>
      </table>
        </fieldset>
     </td>
  </tr>
</table>