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 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; }
You can create a stored procedure or a trigger on inserting that implement your id logic.
-- Mickaël Wolff aka Lupus Michaelis http://lupusmic.org 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
