$query = 'SELECT sku, title FROM products ORDER BY id'; foreach ($dbh->query($query) AS $row) { $sku = $row['sku']; $title = $row['title']; printf("Product: %s (%s)
", $title, $sku); }