pg_fetch_Assoc1.htm
Script: pg_fetch_Assoc1.txt

$dbconn = pg_connect ("host=$host dbname=$db user=$user password=$pass");
$result = pg_query($dbconn,"SELECT * FROM emp2");
echo "<table >";
while($row=pg_fetch_assoc($result))
{
echo "<tr>";
echo "<td class='td0' align='center' >" . $row['eid'] . "</td>";
echo "<td class='td0' align='center' >" . $row['fname'] . "</td>";
echo "<td class='td0' align='center' >" . $row['lname'] . "</td>";
echo "<td class='td1' align='center' >" . $row['job'] . "</td>";
echo "<td class='td0' align='center' >" . $row['deptno'] . "</td>";
echo "<td class='td2' align='center' >" . $row['hired'] . "</td>";
echo "<td class='td2' align='center' >" . $row['released'] . "</td>";
echo "<td class='td1' align='center' >" . $row['salary'] . "</td>";
echo "<td class='td1' align='center' >" . $row['comm'] . "</td>";
echo "</tr>";
}
echo "</table>";