| Job ID | Job Title | Deadline for Application |
|---|
open(_DB_NAME_, _DB_HOST_, _DB_PORT_, _DB_USER_, _DB_PASSWORD_);
$sql = "select jobids.jobid, fieldvalues.value, jobids.id, fieldvalues.fieldnameid, fieldname, fieldnames.id, jobids.id, jobids.display from fieldvalues, fieldnames, jobids where fieldvalues.jobid=jobids.id and fieldvalues.fieldnameid=fieldnames.id and jobids.display='t' and (fieldnames.id=1 or fieldnames.id=2 or fieldnames.id=5) order by jobids.id, fieldnames.id";
$result = $db->query($sql);
$num_rows = $db->num_rows($result);
$job_id = "";
for ($i=0;$i<$num_rows; $i++) {
if ($job_id != $db->result($result,$i,"jobid")) {
if ($job_id != "") {
$url = "description.php?id=$id";
print "| $job_id | $title | $deadline
(still accepting applications) |
";
}
$job_id = $db->result($result,$i,"jobid");
$id = $db->result($result,$i,"id");
$title = " ";
$deadline = " ";
}
switch($db->result($result,$i,"fieldname")) {
case "Job Title":
$title = $db->result($result,$i,"value");
break;
case "Application Deadline":
$deadline = $db->result($result,$i,"value");
break;
}
}
if ($job_id != "") {
$url = "description.php?id=$id";
print "| $job_id | $title | $deadline
(still accepting applications) |
";
}
$db->close();
?>
