";
$sql = "SELECT * FROM emp ORDER BY ename";
$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->empno | $row->ename | $row->job |
$row->mgr |
$row->hiredate | $row->sal | $row->comm | $row->deptno |
");
}// while bolck ends
print("
");
}
//
pg_close($dbconn);
?>