define(array(template => 'work-with-us.html', job_row => 'job_row.html')); $itemNo = 1; $jobList = NULL; $tpl->assign(array(VAR_JOB_ROW => NULL)); $sql = "SELECT * FROM career_position_tbl WHERE status = 'E' ORDER BY ordinal ASC "; $rs = $ado->Execute($sql); $totalRecord = $rs->RecordCount(); while ($jobObj = $rs->FetchNextObject()) { $tpl->assign(array(VAR_JOB_ID => $jobObj->ID)); $name = stripslashes($jobObj->NAME); $jobList .= "

".$name.""; $tpl->assign(array(VAR_NAME => $name)); $urgent = ($jobObj->URGENT == "Y") ? " " : NULL; $tpl->assign(array(VAR_URGENT => $urgent)); $tpl->assign(array(VAR_DESCRIPTION => stripslashes($jobObj->DESCRIPTION))); $tpl->parse(VAR_JOB_ROW, ".job_row"); } $tpl->assign(array(VAR_JOB_LIST => $jobList)); $tpl->parse(TEMPLATE, "template"); $tpl->FastPrint(TEMPLATE); ?>