function new_id($table,$column,$connection,$length=128){
$new_id = create_rand_str($length);
$sql = mysql_query("select * from $table where $column='$new_id'", $connection)or die(mysql_error());
$num = mysql_num_rows($sql);
if($num!=0){
$new_id = new_id($table,$column,$connection,$length);
}
return $new_id;
}
//Example: new_id("bugs", "bug_id", $db);
//
//Returns: "b7RmJ7rtRhbXcIEktcS9b83mGLveZ13mum0xkihEOdpNS819VN6CrHl2Mv85YJ1YH09Z4aAWcqT01v9n2FLzxU0bPcL3ewm5A5nTrHoLOa3iv5vNA1BofAXBRKB6BiZL"
//create a random string of a specified length
function create_rand_str($length)
{
$charset = "abcdefghijklmnopqrstuvwxyz";
//$charset .= "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
$charset .= "0123456789";
for ($i=0; $i<$length; $i++) $key .= $charset[(mt_rand(0,(strlen($charset)-1)))];
return $key;
}
?>
All Craftsmen