"; $sql = 'SELECT DISTINCT fname, lname, dob FROM birthdays ORDER BY fname'; echo "query used
:". $sql."
"; try { $stmt = $dbh->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL)); print "
fname , \t lname , \t dob "; $stmt->execute(); while ($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) { $data = $row[0] . ",\t " . $row[1] . ",\t" . $row[2] ; 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(); } ?>