aveev wrote:
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

    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;

You can create a stored procedure or a trigger on inserting that implement your id logic.

Mickaël Wolff aka Lupus Michaelis

Seeking for a position <http://lupusmic.org/pro/>

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to