";
$sql = "SELECT * FROM emp1 ORDER BY fname";
$result = pg_query($dbconn,$sql);
if (!$result) {
echo "An error occured.\n";
exit;
}
echo"query string " .$sql."
";
// html table format
if(pg_num_rows($result)>0)
{
print("| eid | fname | lname | address | manager |
|---|
");
//
while($row=pg_fetch_object($result)){
print("| $row->eid | $row->fname | $row->lname |
$row->address |
$row->manager |
");
}// while bolck ends
print("
");
}
//
pg_close($dbconn);
?>