//connection
$conn_string = "host=/var/run/postgresql dbname=prao user=www-prao";
$db = pg_connect($conn_string);
$idN = $_GET['idD'];
if($db) {
$query = "SELECT name_div, name_head FROM divisionE WHERE id='$idN'";
$result = pg_exec($db, $query);
$numb = pg_numrows($result);
$rowFromTable = pg_fetch_array($result);
$nameDiv = $rowFromTable["name_div"];
$nameHead = $rowFromTable["name_head"];
$query = "SELECT name, post, name_lab, laboratoryE.name_head as lab_head
FROM staffE, laboratoryE
WHERE staffE.div_id = '$idN' AND laboratoryE.id = staffE.lab_id
ORDER BY name_lab, name";
$result = pg_exec($db, $query);
//print " numb = $numb
";
$rowFromTable = pg_fetch_array($result);
} else {
print "Can't create connection
";
exit;
}
?>
|
|
|
|
echo $nameDiv ?> |
if(!empty($nameHead)) { ?>
echo $nameHead ?> |
} ?>
$fl_table=0;
$nameL="";
while (is_array($rowFromTable)) {
$name = $rowFromTable["name"];
$post = $rowFromTable["post"];
$name_lab = $rowFromTable["name_lab"];
$lab_head = $rowFromTable["lab_head"];
if (!empty($name_lab) AND ($name_lab!="no laboratory")) {
if($name_lab == $nameL) {
echo " | ";
echo " ". $name ." | ";
if($post) {
$addr = "mailto:".$post;
echo " ". $post ." | ";
} else {
echo "   | ";
}
echo " ";
} else {
$nameL = $name_lab;
if($fl_table=="1") {
echo " ";
$fl_table=0;
}
echo "";
echo " ";
if(empty($lab_head)) {
echo " ".$name_lab." | ";
} else {
echo " ".$name_lab." ".$lab_head ." | ";
}
echo " ";
echo " ";
echo "";
echo " ";
echo " ". $name ." | ";
if($post) {
$addr = "mailto:".$post;
echo " ". $post ." | ";
} else {
echo "   | ";
}
echo " ";
$fl_table=1;
}
} else {
if($fl_table=="0") {
$fl_table = 1;
echo "";
}
echo "";
echo " ". $name ." | ";
echo " ". $post ." | ";
echo " ";
}
$rowFromTable=pg_fetch_array($result);
}
pg_close($db);
if($fl_table == "1") {
echo " ";
}
?>
|
|
|
|
|
|