$area = $_POST["order_by"]; include('sqlconnect.php'); if (isset($area)) $query = mysql_query("SELECT * FROM jobs WHERE `active`='1' AND `discipline`='$area' ORDER BY `discipline`"); else $query = mysql_query("SELECT * FROM jobs WHERE `active`='1' ORDER BY `discipline`"); $num_rows = mysql_num_rows($query); $query2 = mysql_query("SELECT DISTINCT `discipline` FROM jobs WHERE `active`='1' ORDER BY `discipline`"); $num_rows2 = mysql_num_rows($query2); $query3 = mysql_query("SELECT * FROM jobs WHERE `job_of_the_week`='1' ORDER BY `discipline`"); $num_rows3 = mysql_num_rows($query3); ?>
|
|
||
| Testimonials | |||
![]() |
|||
| Latest Vacancies | |||
|
While( $rows3 = MySQL_fetch_array($query3) ) { $id = $rows3['id']; $discipline = $rows3['discipline']; $title = $rows3['title']; $description = $rows3['description']; $description = nl2br($description); $salary = $rows3['salary']; $location = $rows3['location']; $hourspw = $rows3['hourspw']; $requisites = $rows3['requisites']; $requisites = nl2br($requisites); $temp_perm = $rows3['temp_perm']; ?>
} ?>
|