<?php

$res = mysql_query('SELECT * FROM `users`');

while($row = mysql_Fetch_assoc($res)) {
    echo $row['username'];
}
?>