{source}
<!-- You can place html anywhere within the source tags -->


<script language="javascript" type="text/javascript">
// You can place JavaScript like this

</script>
<?php


$db=mysql_pconnect('mysql.etisp.et','ordadb','test@123');

if(!$db)
{
echo 'could not connect to server';
exit;

}
//mysql_select_db('vacancy');
if(!mysql_select_db('ordadb')){
echo 'database not connected';

}


$jid =$_POST['ID'];

echo " <label></label><input type=hidden name=jid value=" .$jid. "><br />";

$kal=mysql_query("DELETE FROM jos_jobpost WHERE j_id=$jid ");

if(!$kal){
echo "not deleted row";
}

else {
$result=mysql_query("SELECT 'j_position' FROM jos_jobpost WHERE j_id=$jid ");
$row = mysql_fetch_array($result);
$jobposition=$row['j_position'];
echo " Job IS Deleted"."<br/>";

$result=mysql_query("select * from jos_jobpost ");
echo "<Table border=2 cellpadding=5 cellspacing=5 border-color=#000000 bgcolor=#FF0066>
<tr bgcolor=#00CC33>
<td width='auto'>No</td>
<td width=10>Position </td>

<td width='auto'>Exeperiance</td>
<td width='auto'>Description</td>

<td width='auto'>No of Required</td>
<td width='auto'>Payment</td>
<td width='auto'>DeadLine Date</td>
<td width='auto'>Action</td>
</tr>";
$i=1;
echo "<caption>Available Job List</caption>";
while($row = mysql_fetch_array($result)) {
echo "<tr bgcolor=#F3F9FF> <td>".$i."</td>";
$currentID=$row['j_id'];

echo "<td>".$row['j_position'] . "</td><td>" . $row['j_experiance'] . "</td><td> " . $row['j_educationlevel']. " in ". $row['j_educationtype']." " .
$row['j_description'] . " </td><td>" . $row['j_noofrequired'] . "</td><td> " . $row['j_payement'] . "</td><td>" . $row['j_deadlinedate'] ."</td>
<td> <form action=index.php?option=com_content&view=article&id=59:delete-vacancy&catid=37:vacancy-maneger method=POST>
<INPUT TYPE=HIDDEN NAME=ID value= ".$currentID." /><input type=submit value=Delete></form>
<form action=# method=POST>
<INPUT TYPE=HIDDEN NAME=ID value= ".$currentID." /><input type=submit value=Edit></form></td> ";

echo "</tr>";
$i++;
}
echo "</table>";

}


?>
{/source}