connect(); $selectCounties = "SELECT DISTINCT region FROM job WHERE status='Published' AND CURDATE() <= DATE_ADD(closing_date,INTERVAL 2 DAY)"; $counties = $mysql->query($selectCounties); $selectRole = "SELECT DISTINCT role FROM job WHERE status='Published' AND CURDATE() <= DATE_ADD(closing_date,INTERVAL 2 DAY)"; $roles = $mysql->query($selectRole); //read out the published jobs from the db $selectPublished = "SELECT * FROM job WHERE status='Published'"; if(isset($_POST['job_role'])) { $jRole = $_POST['job_role']; if($_POST['job_role'] != "All available") $selectPublished = $selectPublished . " AND role='$jRole'"; } if(isset($_POST['county'])) { if($_POST['county'] != "All locations") $selectPublished = $selectPublished . " AND region='$_POST[county]'"; } $selectPublished = $selectPublished . " AND CURDATE() <= DATE_ADD(closing_date,INTERVAL 2 DAY) ORDER BY closing_date ASC"; //echo $selectPublished; $published = $mysql->query($selectPublished); $mysql->end(); while($row = mysql_fetch_array($published)) { $row['mysqldate'] = gmdate('j M Y',strtotime( $row['closing_date'].' UTC')); if($row['featured']) { $feat_jobs[] = $row; } else { $jobs[] = $row; } } ?> <? echo $titleprefix; ?>Occupational Health | Job Upload
[ Go to home page ]
Accessibility
Set colour scheme:
Normalnormal  High Contrasthigh contrast

Valid HTML 4.01 Transitional Valid CSS!

Advertise OH Jobs

Employers & Recruiters

Do you have an occupational health job to advertise? Simply upload your job to our website by completing our short OH job upload form...

Find out more Upload a Job

Find OH Jobs

Looking for OH Jobs? Our latest OH vacancies are listed below - click through for details.

Show