"")) { $keyword=$_REQUEST["keyword"]; $strpass.="&keyword=".$_REQUEST["keyword"]; if (!get_magic_quotes_gpc()) { $searchkeyword=str_replace('$', '\$',addslashes($_REQUEST["keyword"])); } else { $searchkeyword=str_replace('$', '\$',$_REQUEST["keyword"]); } $searchkeyword=trim($searchkeyword); } if(isset($_REQUEST["cid_list"])&&($_REQUEST["cid_list"]<>"")) { $strpass.="&cid_list=".$_REQUEST["cid_list"]; $cid_list=str_replace(";",",",$_REQUEST["cid_list"]); //$cid_list=explode(";",$_REQUEST["cid_list"]); } $cid=0; if(isset($_REQUEST["cid"])&&($_REQUEST["cid"]<>"")) { $strpass.="&cid=".$_REQUEST["cid"]; $cid=$_REQUEST["cid"]; $c_list=$_REQUEST["cid"]; $child_cat=mysql_query("select * from sbjbs_categories where sb_pid=".$_REQUEST["cid"]); while ( $child=mysql_fetch_array($child_cat) ) { $c_list.="," . $child["sb_id"]; while ( $child=mysql_fetch_array($child_cat) ) { $c_list.="," . $child["sb_id"]; } $child_cat=mysql_query("Select * from sbjbs_categories where sb_pid IN (" . $c_list . ") and sb_id not in ( ". $c_list . ")") ; } $cid_list=$c_list; } //=================================catpath code $catname=""; $category=0; $cat_query=mysql_query("Select * from sbjbs_categories where sb_id=" . $cid ); if ($cat=mysql_fetch_array($cat_query)) { $catname=$cat["sb_cat_name"]; $category=$cat["sb_id"]; } $catpath=""; $cat_query=mysql_query("Select * from sbjbs_categories where sb_id=" . $cid ); while ($rs=mysql_fetch_array($cat_query)) { $catpath =" > " .$rs["sb_cat_name"]."".$catpath; $cat_query=mysql_query("Select * from sbjbs_categories where sb_id=" . $rs["sb_pid"] ); } //================================== LOC SEARCH [MULTI LOCATION CODE] ==================================== if(isset($_REQUEST["loc_id"])&&($_REQUEST["loc_id"]<>"")) { $strpass.="&loc_id=".$_REQUEST["loc_id"]; $loc_id_list=str_replace(";",",",$_REQUEST["loc_id"]); $loc_q=mysql_query("select * from sbjbs_locations where sb_id in ($loc_id_list)"); while($loc=mysql_fetch_array($loc_q)) { $clist=$loc["sb_id"]; $child_loc=mysql_query("select * from sbjbs_locations where sb_pid=".$loc["sb_id"]); while ( $child=mysql_fetch_array($child_loc) ) { $clist.="," . $child["sb_id"]; while ( $child=mysql_fetch_array($child_loc) ) { $clist.="," . $child["sb_id"]; } $child_loc=mysql_query("Select * from sbjbs_locations where sb_pid IN (" . $clist . ") and sb_id not in ( ". $clist . ")") ; } } $loc_id_list.=",".$clist; //$loc_id_list=explode(",",$loc_id_list); } $sbq_job="select *,UNIX_TIMESTAMP(sb_posted_on) as sbposted from sbjbs_jobs where sb_approved='yes' and sb_company_id not in ($disapproved_list) "; //===================================== keyword search ================================================== if($searchkeyword<>"") { if(isset($_REQUEST["search_method"])&&(($_REQUEST["search_method"]==2)||($_REQUEST["search_method"]==3))) { $log_operator="OR"; if($_REQUEST["search_method"]==2) $log_operator="AND"; $search_str=""; $keyword_arr=explode(" ",$searchkeyword); foreach($keyword_arr as $key) { if($search_str=="") { $search_str="(sb_title like '%$key%' or sb_description like '%$key%' or sb_role like '%$key%') "; } else { $search_str.=" $log_operator (sb_title like '%$key%' or sb_description like '%$key%' or sb_role like '%$key%') "; } } $sbq_job.=" and ($search_str)"; }// end if AND/ OR keywords else { $sbq_job.=" and (sb_title like '%$searchkeyword%' or sb_description like '%$searchkeyword%' or sb_role like '%$searchkeyword%') "; } } //============================================================ //=======================category search========================== if((count($cid_list)>0)&&($cid_list<>"")) { $cat_str="-1"; $job_cat_q=mysql_query("select * from sbjbs_job_cats where sb_cid in ($cid_list)"); while($job_cat=mysql_fetch_array($job_cat_q)) { $cat_str.=",".$job_cat["sb_job_id"]; } $sbq_job.=" and sb_id in ($cat_str)"; } //================================================================ //=======================Location search========================== if((count($loc_id_list)>0)&&($loc_id_list<>"")) { $loc_str="-1"; $job_loc_q=mysql_query("select * from sbjbs_job_locs where sb_lid in ($loc_id_list)"); while($job_loc=mysql_fetch_array($job_loc_q)) { $loc_str.=",".$job_loc["sb_job_id"]; } $sbq_job.=" and sb_id in ($loc_str)"; } //================================================================ //===================================== Experience Search ================================= if(isset($_REQUEST["work_exp"])&&($_REQUEST["work_exp"]<>"")) { $strpass.="&work_exp=".$_REQUEST["work_exp"]; $sbq_job.=" and (sb_experience=".$_REQUEST["work_exp"]." or sb_experience=-1)"; } //===================================Company Search=========================================== if(isset($_REQUEST["company"]) &&($_REQUEST["company"]<>"")) { $strpass.="&company=".$_REQUEST["company"]; $sbq_job.=" and sb_company_id=".$_REQUEST["company"]; } //========================================================================================= $sbq_job.=" order by sb_featured desc, sb_id desc"; //echo $sbq_job; $sbq_job=mysql_query($sbq_job); $num_job=mysql_num_rows($sbq_job); $strpass1=$strpass; if(isset($_REQUEST["view"])&&($_REQUEST["view"]<>"")) { $strpass.="&view=".$_REQUEST["view"]; $view=$_REQUEST["view"]; } ///////////////////////////////////PAGINATION ///////// if(!isset($_REQUEST["pg"])) { $pg=1; } else { $pg=$_REQUEST["pg"]; } $rcount=mysql_num_rows($sbq_job); if ($rcount==0 ) { $pages=0; } else { $pages=floor($rcount / $recperpage); if (($rcount%$recperpage) > 0 ) { $pages=$pages+1; } } $jmpcnt=1; while ( $jmpcnt<=($pg-1)*$recperpage && $row = mysql_fetch_array($sbq_job) ) { $jmpcnt = $jmpcnt + 1; } //////////////////////////////////////////////////////////////////////// $label=1; $featured_label=1; ?>

Any Location      Advanced Search    Home

Total Job(s) Found