//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;
}
?>
  
    |  | 
  
    | 
        
          |  | 
              
                | 
                    
                      |  |  
                      |  |  
                      | 
                          
                            if(!empty($nameHead)) { ?>| echo $nameDiv ?> |  
                            } ?>| echo $nameHead ?> |  
 
                          ";
                                    $fl_table=0;
                                  }
						        echo "
                            | $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 "  ";
                               } else {
                                  $nameL = $name_lab;
                                  if($fl_table=="1") {
						   	        echo "| ". $name ."";
                                 if($post) {
                                   $addr = "mailto:".$post;
						       	   echo " | ". $post ."";
                                 } else {
                                   echo " |  ";
                                 }
						   	     echo " |  ";
						        echo "  ";
						        echo "";
                                if(empty($lab_head)) {
						          echo "  ";
						   	    echo "| ".$name_lab."";
                                } else {
						          echo " | ".$name_lab." ";
                                }
						   	    echo "".$lab_head ."
 |  ";
						        echo "  ";
						        echo "    ";
                                $fl_table=1;
                               }
                             } else {
                               if($fl_table=="0") {
                                 $fl_table = 1;
                                 echo "| ". $name ."";
                                 if($post) {
                                   $addr = "mailto:".$post;
						       	   echo " | ". $post ."";
                                 } else {
                                   echo " |  ";
                                 }
						   	    echo " |  ";
                               }
						       echo "";
                             }
							 ?>";
						       echo "  ";
                             }
							 $rowFromTable=pg_fetch_array($result);
							 }
						 	 pg_close($db);
                             if($fl_table == "1") {
						       echo "| ". $name ."";
						   	   echo " | ". $post ."";
						   	   echo " |  |  
                      |  |  |  
                |  |  |  |