/home/mip/public_html_/old_mip/admin/manage_jobs.php
<?
/* The page for managing the Job Openings */
session_start();
require_once("func_proc.php");
require_once("func_select.php");
if($msg) echo "<script>alert('$msg')</script>";
do_html_header("Job Manager");
?>
<tr><td height="100%" align=center valign="top">
<TABLE BORDER=0 align=center cellpadding='2' cellspacing='2' width=98%>
<tr height=30><td colspan=6 class=trtitle><br>
<a href='edit_job.php?Action=add'> <b><font color="#3399FF">Add Job Opening</font></b> </a><br><br></td>
</tr>
<TR>
<TD colspan='2' bgcolor=#ffff00 width=26%><font color=black><b>Position</b></font></TD>
<TD colspan='1' bgcolor=#c0c0c0 width=20%><font color=black><b>Country</b></font></TD>
<TD colspan='1' bgcolor=#c0c0c0 width=20%><font color=black><b>Principal</b></font></TD>
<TD colspan='1' bgcolor=#c0c0c0 width=13%><font color=black><b>Date Posted</b></font></TD>
<TD colspan='2' bgcolor='#c0c0c0' width=21%><font color=black><b>Expiration</b></font></TD>
</TR>
<?
$jobs = getdata("select * from webjobs order by posting_date desc");
$num_jobs = count($jobs);
for ($count = 1; $count <= $num_jobs; ++$count)
{
//$position_name=getname($jobs[$count]["position_id"],"positions","position_id");
echo mysql_error();
?> <TR>
<TD bgcolor='#c0c0c0' align=right width=1%><?=$count?></TD>
<TD bgcolor='e0e0e0'><a href="edit_job.php?Action=edit&webjobid=<?=$jobs[$count]["webjobid"]?>"><?=$jobs[$count]["position"]?></a></TD>
<TD bgcolor='e0e0e0'><a href="edit_job.php?Action=edit&webjobid=<?=$jobs[$count]["webjobid"]?>"><?=$jobs[$count]["country"]?></a></TD>
<TD bgcolor='e0e0e0'><a href="edit_job.php?Action=edit&webjobid=<?=$jobs[$count]["webjobid"]?>"><?=$jobs[$count]["principal"]?></a></TD>
<TD bgcolor='e0e0e0'><?=dateformat($jobs[$count]["posting_date"])?></a></TD>
<TD bgcolor='e0e0e0'><?=dateformat($jobs[$count]["closing_date"])?></a></TD>
<?if(in_array($accessID,$delete_access)) {?>
<TD bgcolor='e0e0e0' width=5%><a href="sqldelete.php?what=webjob&webjobid=<?=$jobs[$count]["webjobid"]?>"
onclick="return confirm('Are you sure you want to delete <?=$position_name?>?')"><font color=maroon>Delete</font></a></TD>
<?}?>
</TR>
<? }
?>
</TABLE>
</td></tr>
</form>
<?
do_html_footer();
?>
