note 113378 deleted from pdo.query by levim
| From: | levim@php.net | Date: | Thu, 05 Dec 2013 03:31:48 +0000 |
| Subject: | note 113378 deleted from pdo.query by levim | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-197746@lists.php.net to get a copy of this message | ||
Note Submitter: angerangel at gmail dot com
----
Nesting foreach can be full of trouble, you have to repeat the query before every foreach to avoid
blank results:
<?php
//Create list of files
$query = "SELECT filename FROM files ORDER BY filename" ;
$files = $db->query($query);
foreach ($files as $file) {
#example code of first foreach
echo $file['filename'] ;
#example code of nested foreach
$query = "SELECT ID, user FROM users ORDER BY user" ;
$users = $db->query($query);
foreach ($users as $user) {
echo "user: " . $user['user'] ;
echo "user ID: " . $user['ID'] ;
}
}
?>