include "session.php";
include_once "myconnect.php";
include_once "date_time_format.php";
if (!isset($_REQUEST["sb_id"]) || !is_numeric($_REQUEST["sb_id"]) || ($_REQUEST["sb_id"] < 1)) {
header("Location: gen_confirm.php?errmsg=" . urlencode("Invalid access, denied"));
die();
}
/////-----------
$suspended_list = "-1";
$mem_q = mysql_query("select * from sbjbs_employers where sb_suspended='yes'");
while ($mem = mysql_fetch_array($mem_q)) {
$suspended_list.="," . $mem["sb_id"];
}
$disapproved_list = "-1";
$comp_q = mysql_query("select * from sbjbs_companies where
(sb_approved='no' OR sb_uid in ($suspended_list))");
while ($comp = mysql_fetch_array($comp_q)) {
$disapproved_list.="," . $comp["sb_id"];
}
///////---------
function main() {
///////just for icons
global $sbico_apply_user, $sbico_apply_new, $sbico_refer_friend, $sbico_view_profile, $sbrow_job;
/////////////////////
$sbq_con = "select * from sbjbs_config where sb_id=1";
$sbrow_con = mysql_fetch_array(mysql_query($sbq_con));
$sb_null_char = $sbrow_con["sb_null_char"];
$config = mysql_fetch_array(mysql_query("select * from sbjbs_config"));
$policies = mysql_fetch_array(mysql_query("select * from sbjbs_policies"));
$cid = 0;
$suspended_list = "-1";
$mem_q = mysql_query("select * from sbjbs_employers where sb_suspended='yes'");
while ($mem = mysql_fetch_array($mem_q)) {
$suspended_list.="," . $mem["sb_id"];
}
$disapproved_list = "-1";
$comp_q = mysql_query("select * from sbjbs_companies where
(sb_approved='no' OR sb_uid in ($suspended_list))");
while ($comp = mysql_fetch_array($comp_q)) {
$disapproved_list.="," . $comp["sb_id"];
}
// $sb_icon_scheme=$sbrow_con["sb_icon_list"];
$servername='127.0.0.1:3328' ; // Replace this 'localhost' with your server name
$database_username='recruitgib'; // Replace this with your username
$database_password='db128'; // Replace this with your password
$database_name='recruitgib'; // Replace this 'db' with your database name
mysql_connect($servername,$database_username,$database_password);
mysql_select_db($database_name);
$sb_job = mysql_query("SELECT * FROM tbjobs WHERE jobId = " . $_REQUEST["sb_id"] . "");
$sbrow_job = mysql_fetch_array($sb_job);
?>
Job Requirements |
Title |
|
Role |
|
Job Industry |
|
Location |
|
Job Status |
Active
|
|
|
|
|
|
|
|
|
Browse echo date("F"); ?> job vacancies in Gibraltar |
$cats_query = mysql_query("select distinct reqindustry1 from tbjobs where area = 'Gibraltar' and active = 'Yes' order by reqindustry1");
$cnt = 1;
while ($cats = mysql_fetch_array($cats_query)) {
$catscnt_sql = "select count(jobid) as jobcount from tbjobs where area = 'Gibraltar' and active = 'Yes' and (reqindustry1 = '".$cats["reqindustry1"]."' or reqindustry2 = '".$cats["reqindustry1"]."' or reqindustry3 = '".$cats["reqindustry1"]."')";
//echo $catscnt_sql;
$catscnt_query = mysql_query($catscnt_sql);
$catscnt = mysql_fetch_array($catscnt_query);
if ($cnt % 3 == 1) {
?>
}
?>
_jobs_in_Gibraltar">
echo $cats["reqindustry1"]; ?> jobs in Gibraltar( echo $catscnt["jobcount"]; ?>) |
if ($cnt % 3 == 0) {
?>
}
$cnt++;
}
?>
|
}
// end main
include "template.php";
?>