|
|
| Browse Jobs |
$cats_sql="select * from sbjbs_categories where sb_pid=$cid ";
if($config["sb_cat_listing"]=="alpha")
{
$cats_sql.=" order by sb_cat_name";
}
else
{
$cats_sql.=" order by sb_order_index";
}
$cats_query=mysql_query($cats_sql);
$cnt=1;
while($cats=mysql_fetch_array($cats_query))
{
$rst_query=mysql_query("Select * from sbjbs_categories where sb_pid=".$cats["sb_id"] );
$clist=$cats["sb_id"];
while ( $rst=mysql_fetch_array($rst_query) )
{
$clist.="," . $rst["sb_id"];
$thislist="-1," . $rst["sb_id"];
while ( $rst=mysql_fetch_array($rst_query) )
{
$clist.="," . $rst["sb_id"];
$thislist.="," . $rst["sb_id"];
//echo $rst["sbcat_id"];
}
$rst_query=mysql_query("Select * from sbjbs_categories where sb_pid in (" . $thislist . ")" );
}
$sbcat_str= " and sb_cid IN (" .$clist . ")" ;
$sbq_job_cat="select * from sbjbs_job_cats, sbjbs_jobs where sb_approved='yes' and sbjbs_jobs.sb_id=sbjbs_job_cats.sb_job_id and sb_company_id not in ($disapproved_list) $sbcat_str";
$sbtotal=mysql_num_rows(mysql_query($sbq_job_cat));
//die();
if($cnt%3==1)
{
?>
| |
}
?>
">
echo $cats["sb_cat_name"]; ?>( echo $sbtotal; ?>) |
if($cnt%3==0)
{
?>
}
$cnt++;
}
?>
|
|
| Featured Jobs |
Company |
Experience |
|
| Latest Jobs |
Company |
Experience |
|