<?php /** * Include path to core script * */ include PATH_TO_CORE; /** * @var $db \PDO */ /** * Prepare query */ $result = $db->prepare(" select `id`,`login` from `users` where `id` BETWEEN 1 and 100 "); /** * Execute query */ $result->execute(); /** * Fetch data from database * @var array */ $data = $result->fetchAll(PDO::FETCH_ASSOC); /** * Start loop */ foreach ($data as $row) { echo "Id: {$row['id']} | Login: {$row['login']} <br>"; } //foreach