|
|
| Browse Jobs |
$cats_sql="select * from avomc_categories where avomc_pid=$cid ";
if($config["avomc_cat_listing"]=="alpha")
{
$cats_sql.=" order by avomc_cat_name";
}
else
{
$cats_sql.=" order by avomc_order_index";
}
$cats_query=mysqli_query($link, $cats_sql);
$cnt=1;
while($cats=mysqli_fetch_array($cats_query, MYSQLI_BOTH ))
{
$rst_query=mysqli_query($link, "Select * from avomc_categories where avomc_pid=".$cats["avomc_id"] );
$clist=$cats["avomc_id"];
while ( $rst=mysqli_fetch_array($rst_query, MYSQLI_BOTH ) )
{
$clist.="," . $rst["avomc_id"];
$thislist="-1," . $rst["avomc_id"];
while ( $rst=mysqli_fetch_array($rst_query, MYSQLI_BOTH ) )
{
$clist.="," . $rst["avomc_id"];
$thislist.="," . $rst["avomc_id"];
//echo $rst["sbcat_id"];
}
$rst_query=mysqli_query($link, "Select * from avomc_categories where avomc_pid in (" . $thislist . ")" );
}
$sbcat_str= " and avomc_cid IN (" .$clist . ")" ;
$sbq_job_cat="select * from avomc_job_cats, avomc_jobs where avomc_approved='yes' and avomc_jobs.avomc_id=avomc_job_cats.avomc_job_id and avomc_company_id not in ($disapproved_list) $sbcat_str";
$sbtotal=mysqli_stmt_num_rows(mysqli_prepare($link, $sbq_job_cat));
//die();
if($cnt%3==1)
{
?>
| |
}
?>
">
echo $cats["avomc_cat_name"]; ?>( echo $sbtotal; ?>) |
if($cnt%3==0)
{
?>
}
$cnt++;
}
?>
|
|
| Featured Jobs |
Company |
Experience |
$max_allowed)
{
for($i=0;$i<$max_allowed;$i++)
{
$unique=0;
while($unique==0)
{
$j=rand(0,$num_rows-1);
for($k=0;$k(count($number)-1))
{
$unique=1;
}
}
$number[$i]=$j;
}
}// end if num > no_allowed
/*for($k=0;$k$max_allowed)
{
for($k=0;$k
| ">
";}
echo $ff_jobs["avomc_title"];
if($ff_jobs["avomc_bold"]=="yes")
{ echo "";}
?>
|
";}
if($ff_jobs["avomc_bold"]=="yes")
{ echo "";}
echo $comp["avomc_name"];
if($ff_jobs["avomc_bold"]=="yes")
{ echo "";}
if($comp["avomc_show_profile"]=="yes")
{ echo "";}
?>
|
";}
switch($ff_jobs["avomc_experience"])
{
case -1: echo 'No preference'; break;
case 0: echo 'Fresher'; break;
case 1: echo 'Less than 1 Year'; break;
case 2: echo '1 to 2 Years'; break;
case 3: echo '2 to 5 Years'; break;
case 4: echo '5 to 7 Years'; break;
case 5: echo '7 to 10 Years'; break;
case 6: echo '10 to 15 Years'; break;
case 7: echo 'More than 15 Years'; break;
} //end switch
if($ff_jobs["avomc_bold"]=="yes")
{ echo "";}
?>
|
|
| Latest Jobs |
Company |
Experience |
| ">
";}
echo $jobs["avomc_title"];
if($jobs["avomc_bold"]=="yes")
{ echo "";}
?>
|
";}
if($jobs["avomc_bold"]=="yes")
{ echo "";}
echo $comp["avomc_name"];
if($jobs["avomc_bold"]=="yes")
{ echo "";}
if($comp["avomc_show_profile"]=="yes")
{ echo "";}
?>
|
";}
switch($jobs["avomc_experience"])
{
case -1: echo 'No preference'; break;
case 0: echo 'Fresher'; break;
case 1: echo 'Less than 1 Year'; break;
case 2: echo '1 to 2 Years'; break;
case 3: echo '2 to 5 Years'; break;
case 4: echo '5 to 7 Years'; break;
case 5: echo '7 to 10 Years'; break;
case 6: echo '10 to 15 Years'; break;
case 7: echo 'More than 15 Years'; break;
} //end switch
if($jobs["avomc_bold"]=="yes")
{ echo "";}
?>
|
|