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


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

</script>
<?php
// You can place PHP like this

$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';
}
$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'>Exep</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=index.php?option=com_content&view=article&id=42:edit-vacancy&catid=37:vacancy-maneger method=POST>
<INPUT TYPE=HIDDEN NAME=jid value= ".$currentID." /><input type=submit value=Edit name=update></form>

</td> ";

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

?>
{/source}