"; //$sql = 'SELECT eid, fname, lname FROM Emp1 ORDER BY eid'; //$sql = 'SELECT DISTINCT * FROM Emp1 ORDER BY fname'; $sql = 'SELECT DISTINCT * FROM emp1 ORDER BY fname'; echo "query used
:". $sql."
"; try { $stmt = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL)); $stmt->execute(); if($stmt){ echo "executed"; } while ($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) { $data = $row[0] . ",\t " . $row[1] . ",\t" . $row[2] . ",\t" . $row[3]. ",\t" . $row[4]; print "
"; print $data; } $stmt = null; } catch (PDOException $e) { print $e->getMessage(); } } // try { $db = new PDO("pgsql:dbname=pgsdemo1;host=localhost", $user, $pwd ); echo "PDO connection object created"; echo "
with user : ". $user ."and pwd ".$pwd; echo "
"; readData($db); } catch(PDOException $e) { echo $e->getMessage(); } ?>