'; /*** The SQL SELECT statement ***/ $sql = "SELECT * FROM emp1 ORDER BY fname"; /*** fetch into an PDOStatement object ***/ $stmt = $dbconn->query($sql); /*** echo number of columns ***/ $result = $stmt->fetch(PDO::FETCH_NUM); // $result = $stmt->fetch(PDO::FETCH_ASSOC); /*** loop over the object directly ***/ foreach($result as $key=>$val) { echo $key.' - '.$val.'
'; } /*** close the database connection ***/ $dbconn= null; } catch(PDOException $e) { echo $e->getMessage(); } ?>