Random selecteren

		<?php
		// selecteer een gebruiker binnen de level marge van 5
		// eerst level van de speler ophalen
		$player = mysql_query('SELECT gebruikersnaam, level FROM user_abilities WHERE gebruikersnaam = "'.$_SESSION['username'].'"');
		$p_player = mysql_fetch_array($player);
		$p_level = $p_player['level'];
		if($p_level <= 5)
			{$min = 0;
			 $max = $p_level + 5;}
		else
			{$min = $p_level - 5;
			 $max = $p_level + 5;}
			
		$query = mysql_query('SELECT * FROM user_abilities WHERE level BETWEEN '.$min.' AND '.$max.'');
		?>

<?php
		// selecteer een gebruiker binnen de level marge van 5
		// eerst level van de speler ophalen
		$player = mysql_query('SELECT gebruikersnaam, level FROM user_abilities WHERE gebruikersnaam = "'.$_SESSION['username'].'"');
		$p_player = mysql_fetch_array($player);
		$p_level = $p_player['level'];
		if($p_level <= 5)
			{$min = 0;
			 $max = $p_level + 5;}
		else
			{$min = $p_level - 5;
			 $max = $p_level + 5;}
 
		$query = mysql_query('SELECT * FROM user_abilities WHERE level BETWEEN '.$min.' AND '.$max.'');
		?>

SELECT * FROM user_abilities 
WHERE level BETWEEN level-5 AND level+5 
AND gebruikersnaam='".$_SESSION['username']."' 
ORDER BY RAND() 
LIMIT 1

SELECT * FROM user_abilities 
WHERE level BETWEEN level-5 AND level+5 
AND gebruikersnaam='".$_SESSION['username']."' 
ORDER BY RAND() 
LIMIT 1