| |
|
|
|
| |
include 'dshyidf67g.php';
mysql_connect(localhost, $user, $pass);
@mysql_select_db($db) or die("SERVER LOGIN ERROR!");
$action=$_GET["action"];
if($action==1) {$query = "SELECT * FROM jobs ORDER BY id ASC";}
elseif($action==2) {$query = "SELECT * FROM jobs ORDER BY id DESC";}
elseif($action==3) {$query = "SELECT * FROM jobs ORDER BY title ASC";}
elseif($action==4) {$query = "SELECT * FROM jobs ORDER BY title DESC";}
elseif($action==5) {$query = "SELECT * FROM jobs ORDER BY salaryhigh ASC";}
elseif($action==6) {$query = "SELECT * FROM jobs ORDER BY salaryhigh DESC";}
elseif($action==7) {$query = "SELECT * FROM jobs ORDER BY location ASC";}
elseif($action==8) {$query = "SELECT * FROM jobs ORDER BY location DESC";}
else {$query = "SELECT * FROM jobs";}
$result = mysql_query($query);
$num = mysql_numrows($result);
?>
ID
|
TITLE
|
SALARY
|
LOCATION
|
|
$i=0;
while($i<$num)
{
$hj=mysql_result($result,$i,"hotjob");
if($hj==1)
{
$id=mysql_result($result,$i,"id");
$date=mysql_result($result,$i,"date");
$title=mysql_result($result,$i,"title");
$salarylow=mysql_result($result,$i,"salarylow");
$salaryhigh=mysql_result($result,$i,"salaryhigh");
$bonus=mysql_result($result,$i,"bonus");
$location=mysql_result($result,$i,"location");
$representative=mysql_result($result,$i,"representative");
$body=mysql_result($result,$i,"body");
$category=mysql_result($result,$i,"category");
?>
|
|
$issal=1;
if($salarylow==-1 && $salaryhigh==-1) {$issal=0;}
elseif($salarylow==-1) {echo"$"; echo$salaryhigh;}
else {echo"$"; echo$salarylow; echo"-"; echo$salaryhigh;}
if($bonus != "none" && $issal==0) {echo$bonus;}
elseif($bonus != "none" && $issal==1) {echo" +"; echo$bonus;}
elseif($bonus = "none" && $issal==0) {echo"N/A";}
?>
|
| |
$i++;
}
else
$i++;
}
echo" ";
mysql_close();
?>
|
|
|
| |
|
|
|
|