 |
 |
|
 |
| |
NORTH
| POSITION |
REQUIRED EXPERIENCE |
START DATE |
APPLY |
$sql = "SELECT * FROM $table_name WHERE location = 'N' && status != '0' ORDER BY jid DESC";
$result = @mysql_query($sql,$dbconnect) or die("Couldn't Load North Job Listings.");
if (!mysql_num_rows($result)) {
echo "| No openings available... | ";
} else {
while ($row = mysql_fetch_array($result)) {
$jid = $row['jid'];
$location = $row['location'];
$position = $row['position'];
$experience = $row['experience'];
$sdate = $row['sdate'];
?>
| echo "$position"; ?> |
echo "$experience"; ?> |
echo "$sdate"; ?> |
"> |
} } ?>
|
|
 |
|
 |
 |
|
 |
| |
METRO
| POSITION |
REQUIRED EXPERIENCE |
START DATE |
APPLY |
$sql = "SELECT * FROM $table_name WHERE location = 'M' && status != '0' ORDER BY jid DESC";
$result = @mysql_query($sql,$dbconnect) or die("Couldn't Load Metro Job Listings.");
if (!mysql_num_rows($result)) {
echo "| No openings available... | ";
} else {
while ($row = mysql_fetch_array($result)) {
$jid = $row['jid'];
$location = $row['location'];
$position = $row['position'];
$experience = $row['experience'];
$sdate = $row['sdate'];
?>
| echo "$position"; ?> |
echo "$experience"; ?> |
echo "$sdate"; ?> |
"> |
} } ?>
|
|
 |
|
 |
 |
|
 |
| |
SOUTH
| POSITION |
REQUIRED EXPERIENCE |
START DATE |
APPLY |
$sql = "SELECT * FROM $table_name WHERE location = 'S' && status != '0' ORDER BY jid DESC";
$result = @mysql_query($sql,$dbconnect) or die("Couldn't Load South Job Listings.");
if (!mysql_num_rows($result)) {
echo "| No openings available... | ";
} else {
while ($row = mysql_fetch_array($result)) {
$jid = $row['jid'];
$location = $row['location'];
$position = $row['position'];
$experience = $row['experience'];
$sdate = $row['sdate'];
?>
| echo "$position"; ?> |
echo "$experience"; ?> |
echo "$sdate"; ?> |
"> |
} } ?>
|
|
 |
|
 |
|
|
 |
|