26 |
$countries[]=$row; |
$countries[]=$row; |
27 |
} |
} |
28 |
$smarty->assign("countries",$countries); |
$smarty->assign("countries",$countries); |
29 |
|
|
30 |
|
if ($position) { |
31 |
|
$sth = $dbh->prepare("select num,title,job_code,department,location from open_positions where visible is true and num=$position"); |
32 |
|
$sth->execute(); |
33 |
|
if ($row=$sth->fetchrow_hash()) { |
34 |
|
$smarty->assign("position",$row); |
35 |
|
} |
36 |
|
} |
37 |
} elseif ($part == "OpenPositions") { |
} elseif ($part == "OpenPositions") { |
38 |
$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 = $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"); |
39 |
$sth->execute(); |
$sth->execute(); |
54 |
Country: $country |
Country: $country |
55 |
e-mail: $email |
e-mail: $email |
56 |
tel: $tel |
tel: $tel |
57 |
Purpose: $purpose |
Purpose: $purpose $open_position |
58 |
Interest: $intereset |
Interest: $intereset |
59 |
$other_what |
$other_what |
60 |
Comments: |
Comments: |