Current Job Vacancies List
include './email/PHPMailer/config.php'; $querySelect = "SELECT state_list.state,Client.client_brief,Client.Client_ID as Client_ID ,ClientJob.can_apply_yes_no,ClientJob.state_id, ClientJob.ClientJob_ID as ClientJob_ID ,Client.client_alias as ClientName,jobcode, CONCAT(PositionName ,'-', CASE male_allowed WHEN '1' THEN 'Male/' WHEN '0' THEN '' END , CASE female_allowed WHEN '1' THEN 'Female' WHEN '0' THEN '' END) as PositionName, ClientJob.location,Details,SalaryRange , MinExp,minsal,maxsal FROM ClientJob inner join Client on ClientJob.Client_ID=Client.Client_ID inner join state_list on ClientJob.state_id=state_list.state_id where ClientJob.active='1' order by jobcode "; $resultSelect = mysqli_query($link, $querySelect); $num_rows = mysqli_num_rows($resultSelect); ?>| Job Code | Position | Details | Salary | Min exp | Apply |
|---|



