$teammysql = mysql_query("SELECT * FROM member WHERE status='Clan-Leader'"); while($team = mysql_fetch_array($teammysql)) { echo "Navn: $team[navn] - Status: $team[status] }