{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;
}
if(!mysql_select_db('ordadb')){
echo 'database not connected';

}

$jid =$_POST['jid'];
echo " <label></label><input type=hidden name=jid value=" .$jid. "><br />";
$result=mysql_query("SELECT * FROM jos_jobpost where j_id=$jid");
$row = mysql_fetch_array($result);

?>
<form action="index.php?option=com_content&view=article&id=60:edit-vacancy-data&catid=37:vacancy-maneger" method="POST">
<input type="hidden" name="joid" value="<? echo "$row[j_id]"?>"><br/>
Position <input type="text" name="position" maxlength="25" value="<? echo "$row[j_position]"?>"><br/>

Level <select name="level" value="" >
<option></option>
<option>PS 1</option>
<option>PS 2</option>
<option>PS 3</option>
<option>PS 4</option>
<option>PS 5</option>
<option>PS 6</option>
<option>PS 7</option>
<option>PS 8</option>

</select><br/>
Experiance <input type="text" name="Exp" maxlength="25" value="<? echo "$row[j_experiance]"?>"><br/>
Education Level<select name="edulevel" >
<option >10+1</option>
<option>10+2</option>
<option>10+3</option>
<option>Diploma</option>
<option>Bachelor of Science </option>
<option>Bachelor of Art</option>
<option>Masters</option>
<option>PHD</option>
<option>Professor</option>
</select><br/>
<?php

echo 'Education Type'."<select name='edutype'>";
$result1=mysql_query("select * from jos_educationtype ");
while($row1 = mysql_fetch_array($result1)) {

echo "<option>". $row1['Type'] . "<br /> </option>";

}
echo "</select> <br/>";

?>
Payment <input type="text" name="payment" maxlength="25"value="<? echo "$row[j_payement]"?>"><br/>
No of Requireicsd <input type="text" name="noofrequired" maxlength="25" value="<? echo "$row[j_noofrequired]"?>"><br/>
Description <br/> <textarea cols="50" rows="10" name="des" ></textarea ><br/>
DeadLine Date <input type="text" name="dld" maxlength="25" value="<? echo "$row[j_deadlinedate]"?>">(use yyyy-mm-dd format)<br/>
<input type="Submit" name="submit value" value="Update Job">
</form>




<?
mysql_close($db);
?>


{/source}