while (!$newid) { $newid = rand(); $existingid = $vbulletin->db->query_read("SELECT albumid FROM " . TABLE_PREFIX . "myalbumtable WHERE albumid = $newid"); // Those the generated key already exist? if ($existingid['albumid'] == $newid) { unset $newid; } }