|
include("sys_cmn_opendb.inc");
include("sys_cmn_function.php");
$objdb_function = new db_functions();
$establish=new connection(); ?>
$msSQL = "select a.job_gid, a.sl_no, a.job_code, a.job_qualification, a.posting_date, a.closing_date,
a.primary_skillset, a.secondary_skillset, a.positions_available, a.location, a.experience_year, a.experience_month,
a.salary, a.job_title, a.job_detail, a.job_summary, a.remarks, b.jobtype_gid, b.job_type from
res_trn_tjob a, res_mst_tjobtype b where
a.jobtype_gid = b.jobtype_gid and job_gid = '$_GET[job_gid]'";
$rs_job = mysql_query($msSQL,$establish->link);?>
while ($row = mysql_fetch_array($rs_job)) {
$arrposting_date = explode("-",$row['posting_date']);
$lsposting_date = $arrposting_date[2]."-".$arrposting_date[1]."-".$arrposting_date[0];
$arrclosing_date = explode("-",$row['closing_date']);
$lsclosing_date = $arrclosing_date[2]."-".$arrclosing_date[1]."-".$arrclosing_date[0];?>
|
|
|
|
|