//require_once('mailfunction.php');
require_once('../include/conn.php');
session_start();
function validjobs_biodata_modified ($cnic,$conn)
{
$query12 = "select distinct t.gr_job_id, t.gr_case_no || ' [ ' || t.gr_job_title ||' ] ' || t.gr_sub_name as GR_JOB_TITLE from gr_bdsm t
where (trunc(sysdate)- (T.BD_CLOSING_DATE) <=0)
and t.gr_new_nic = $cnic
order by t.gr_job_id";
echo $query12;
/* $query = "select jp.GR_JOB_ID,
'F.4-'||jp.gr_case_no||'/'||trim(to_char(jp.GR_JOB_POST_DATE,'YYYY'))||'-R ['||jp.gr_job_title||']'||js.gr_sub_name as GR_JOB_TITLE
from GR_JOB_POST jp, gr_job_subs js, gr_job_sub_depend jsd
where jp.gr_job_id = jsd.gr_dep_job_id(+)
and jsd.gr_sub_id = js.gr_sub_id(+)
and jp.gr_job_online = 1
and jp.gr_job_id not in (7094)
and GR_ADVERT_ID =2117";
*/
$rjobs12 = OCIParse($conn,$query12);
OCIExecute($rjobs12);
$Select_jobs12 = "";
while(OCIFetchInto($rjobs12,$mod_row12, OCI_ASSOC)) {
$tableValue12 = $mod_row12["GR_JOB_ID"];
$tableShow12 = $mod_row12["GR_JOB_TITLE"];
$Select_jobs12 = $Select_jobs12 . "";
} // end while
return $Select_jobs12;
} // end function
?>