Re: Creating alphanumeric id for a table

At 3:17 PM -0700 9/10/09, aveev wrote:

I want to create user generated id like this : AAA0001 AAA0002 ... AAA0009 AAA0010 where the id consists of 3 alphanumeric characters and 4 numerical digits in the beginning (for numerical digit, it can grow like this AAA10001). I try to use php script to generate id like this, where I use the following script. <?

    function generate_id($num) {
        $start_dig = 4;
        $num_dig = strlen($num);
           $id = $num;
        if($num_dig <= $start_dig) {
            $num_zero = $start_dig - $num_dig;
                   for($i=0;$i< $num_zero; $i++) {
                $id = '0' . $id;
            }
        }
        $id = 'AAA' . $id;
        return $id;
    }

    $app_id = generate_id(1);

?> I assume that I can get increment value/sequence from db (I used harcoded increment value in the code above (generate_id(1))), but I don't know how I can get this incremental value from db.I use mysql 5.0. Or has anyone had another solution to create this alphanumeric id ? Any help would be much appreciated Thanks

aveev: Why get an incremental value from the database? What information does that give you? Why do you want it? And what are you going to do with it? When those questions are answered, then we can help with more informed advice. Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com