--- careers.php	2001/03/02 07:50:37	1.3
+++ careers.php	2001/03/05 13:32:53	1.5
@@ -10,6 +10,7 @@
 $smarty->assign("section",$section);
 
 $title="CAREERS";
+if ($menu_item) $title.=" : $menu_item";
 $lpic="careers"; $lext=".jpg";
 $mpic="careers.gif";
 $main_file="./html/Careers-";
@@ -18,12 +19,21 @@
 	$main=join('',file($main_file));
 } elseif (file_exists("./templates/Careers-".$part.".tpl")) {
 
-	$sth = $dbh->prepare("select iso,name from countries order by name");
-	$sth->execute();
-	while ($row=$sth->fetchrow_hash()) {
-		$countries[]=$row;
+	if ($part == "ApplicationForm") {
+		$sth = $dbh->prepare("select iso,name from countries order by name");
+		$sth->execute();
+		while ($row=$sth->fetchrow_hash()) {
+			$countries[]=$row;
+		}
+		$smarty->assign("countries",$countries);
+	} elseif ($part == "OpenPositions") {
+		$sth = $dbh->prepare("select num,title,job_code,department,location,description,edu_req,qual_req from open_positions where visible is true order by num asc");
+		$sth->execute();
+		while ($row=$sth->fetchrow_hash()) {
+			$positions[]=$row;
+		}
+		$smarty->assign("positions",$positions);
 	}
-	$smarty->assign("countries",$countries);
 
 	$main=$smarty->fetch("Careers-".$part.".tpl");
 } else {