| |
Career Opportunities
Search by Department:
Search by Location:
= '$date'";
if(isset($_GET['dept']) && $_GET['dept'] != 'all')
{
$dept = $_GET['dept'];
$sql .= " AND dept = $dept";
}
if(isset($_GET['loc']) && $_GET['loc'] != 'all')
{
$loc = $_GET['loc'];
$sql .= " AND location = $loc";
}
if(isset($_GET['sort']))
{
$sort = $_GET['sort'];
$sql .= " ORDER BY $sort";
if(isset($_GET['desc']))
$sql .= " DESC";
}
$result = mysql_query($sql, $db);
$numrows=mysql_num_rows($result);
if ($numrows==0){
print ("There are currently no careers posted. Please check back soon. ");
} else {
echo '';
echo '';
if (isset($_GET['sort']) && $_GET['sort']=='id' && !isset($_GET['desc']))
echo '| Posting | ';
else
echo 'Posting | ';
if (isset($_GET['sort']) && $_GET['sort']=='career' && !isset($_GET['desc']))
echo 'Career | ';
else
echo 'Career | ';
if (isset($_GET['sort']) && $_GET['sort']=='name' && !isset($_GET['desc']))
echo 'Location | ';
else
echo 'Location | ';
if (isset($_GET['sort']) && $_GET['sort']=='date_close' && !isset($_GET['desc']))
echo 'Closing Date | ';
else
echo 'Closing Date | ';
echo ' ';
while ($row = mysql_fetch_array($result))
{
echo '';
echo '| '.$row['id'].' | ';
echo ''.$row['career'].' | ';
echo ''.noblank($row['name']).' | ';
echo ''.noblank($row['date_close']).' | ';
echo ' ';
}
echo ' ';
}
?>
|
|
|
