include "../common/header_job.php"; include "../common/connection.php"; if($pageSize=="") $pageSize = 20; else $pageSize=(int)($pageSize); if ($pageNo == null || $pageNo < 1) { $pageNo = 1; } $pageSize = 20; $pageList = 10; $fNo = ($pageNo- 1) * $pageSize; $query_limit = " limit $fNo, $pageSize"; if($curPage=="") $curPage=1; else { $curPage=(int)($curPage); if($curPage<0) $curPage=1; } if($searchlocation=="" && $searchword=="") { $searchlocation=""; $searchword=""; $SqlWhere=""; } else { if($searchlocation!="") $SqlWhere = $SqlWhere." AND off_Location LIKE '%$searchlocation%'"; if($searchword!="") { $SqlWhere = $SqlWhere." AND (off_Title LIKE '%$searchword%'"; $SqlWhere = $SqlWhere." OR off_Text LIKE '%$searchword%')"; } } //SqlWhere="AND off_Approved=1" if($OrderBy=="") $OrderBy="Date"; else $OrderBy=$OrderBy; if($OrderBy=="Date") $SqlOrderBy = "off_Regi$OrderBy DESC"; else $SqlOrderBy="off_$OrderBy ASC"; $sql = "SELECT off_No FROM Job_Offered WHERE off_No>0".$SqlWhere; $totRecord = mysql_num_rows(mysql_query($sql, $connect)); $totPage = $totRecord / $pageSize; if ($totRecord % $pageSize != 0) $totPage = $totPage + 1; $goNext = $goNext; $goPrev = $goPrev; if($goNext) { $curPage = $curPage + 1; if($curPage>$totPage) $curPage = $totPage; } if($goPrev) { $curPage = $curPage - 1; if($curPage<1) $curPage = 1; } $SkipRecord = $pageSize * ($curPage-1); //$sql="SELECT * FROM Job_Offered WHERE off_No>0 $SqlWhere AND off_No NOT IN (SELECT top $SkipRecord off_No FROM Job_Offered WHERE off_No>0 $SqlWhere ORDER BY $SqlOrderBy) ORDER BY $SqlOrderBy"; $sql="SELECT * FROM Job_Offered WHERE off_No>0 $SqlWhere AND off_No ORDER BY $SqlOrderBy"; //echo $sql.$query_limit; $result = mysql_query($sql.$query_limit, $connect); //echo mysql_num_rows($result); $pageCount = ceil($totRecord / $pageSize); //¹«Á¶°Ç ¹Ý¿Ã¸²Çؼ ¸¶Áö¸· ÆäÀÌÁö¸¦ Ç¥½ÃÇÏ°Ô ÇÑ´Ù. ?>
| Home > Job Board > Index | |
|
Your search for all jobs for "=$searchword?>", viewing matches =($SkipRecord+1)?>-=($curPage*$pageSize)?> below: (sorted by =$OrderBy?>) |
Post New Job Ad. |