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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php