$query = mysql_query("SELECT username FROM users"); while($user = mysql_fetch_array($query)){ $username = $user['username']; echo "<option value=\"$username\">$username</option>"; }