php mysql 随机,PHP MySQL生成唯一的随机数

I don't understand why my code isn't working. The connection works and everything else however when I try to generate a unique random number and check from the MySQL if the number is there it still prints out a random number but it's not UNIQUE. Could anyone help me thx?

Here's my code:

$num = rand(1,5);

$sel_query = "SELECT * FROM test";

$result2 = $con->query($sel_query);

$i = 1;

for (;$i<2; $i++)

{

while($row = mysqli_fetch_array($result2))

{

if ($row['id'] == $num)

{

$num = rand(1,5);

$i = 0;

}

}

}

解决方案

This should work:

$is_unique = false;

$num = false;

while (!$is_unique){

$num = rand(1,5);

$sel_query = "SELECT id from test where id = " . $num;

$result2 = $con->query($sel_query) or die($conn->error);

if (!mysqli_fetch_array($result2)){

$is_unique = true;

}

}

echo "Unique number is " . $num;

But if there aren't any more possible unique numbers, it will loop forever.