<?php include PATH_TO_CORE; /** * * @var $db PDO */ $result = $db->prepare(" select `id`,`login` from `users` "); $result->execute(); $data = $result->fetchAll(PDO::FETCH_ASSOC); foreach ($data as $row) { ?> <a href = "/user/<?php echo $row['id'];?>"> <?php echo $row['login'];?> </a> <br> <?php }