note 113378 added to pdo.query

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'] ; } } ?> ---- Server IP: 69.147.83.199 Probable Submitter: 83.103.10.149 ---- Manual Page -- http://php.net/manual/en/pdo.query.php Edit -- https://master.php.net/note/edit/113378 Del: integrated -- https://master.php.net/note/delete/113378/integrated Del: useless -- https://master.php.net/note/delete/113378/useless Del: bad code -- https://master.php.net/note/delete/113378/bad+code Del: spam -- https://master.php.net/note/delete/113378/spam Del: non-english -- https://master.php.net/note/delete/113378/non-english Del: in docs -- https://master.php.net/note/delete/113378/in+docs Del: other reasons-- https://master.php.net/note/delete/113378 Reject -- https://master.php.net/note/reject/113378 Search -- https://master.php.net/manage/user-notes.php