Help altering random number query

[Shamrox]

I have this working query, but if it finds a duplicate number, I'd like it to continue looping thru until if finds a unique number. How would I alter this?

 

$sql = "SELECT pin FROM `pin_users` ORDER BY pin ASC";
$results = mysql_query($sql);
while($row = mysql_fetch_array($results, MYSQL_NUM)){
	$data[] = $row[0];
	$rando = rand(10000, 99999);
	}
	if (in_array($rando, $data)) {
    	echo "Got Dup";
}else{
		$rando;
	}

[fenway]

in_array() is painfully slow, from what I've read.

 

It would be easier to get all of the PINs (no need to sort), put them in a hash, and then run a while loop using rand() until there's no hash collision.

[Shamrox]

I'm unsure what you mean by put into a hash

[fenway]

I'm unsure what you mean by put into a hash

Then this is the wrong forum..... moving to php.