
I'm trying to learn OOP and convert some old scripts to the latest. (Testing all this locally) I can't see why I cannot get either of the loops to work below. If I comment out var_export($row); everything gets out-putted so I know my connection and query is OK.
Any ideas as to what else I need to try as I've exhausted my research at the mo ?
Thank you.
<?PHP $stmt = $pdo->prepare("SELECT * FROM queue ORDER BY customer_name ASC");
$stmt->execute();
$row = $stmt->fetchAll(PDO::FETCH_ASSOC);
if(!$row) exit('No rows');
echo $stmt->rowCount();
//var_export($row);
//$stmt = null;
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo $row['date_due'];
echo $row['customer_name'];
}
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach($results as $row) {
echo $row['date_due'];
echo $row['customer_name'];
} ?>