Hi, i need to generate a ramdom number and check if already exist on a row of one mysql table if exist generate another and check again and loop this until one unique set of numbers is generated.
$number = rand(0000,9999);
// here must check if already exist if yes then generate another and check again and again until one available is generated.
// save data
$query = “insert into datos
(number) values
(’$number’)”;
mysql_query($query) or
die (mysql_error());
Please help