function readData($dbh) {
echo "function readData<br/>";
//$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 <br/> :". $sql."<br/>";
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 "<br/>";
print $data;
}
$stmt = null;
}
catch (PDOException $e) {
print $e->getMessage();
}
}