in this case, you should manage the "keys" by your application, and
store the used ids in aonther table,
similar to a "sequence" in Oracle or Postgresql.
Thats so if you want all the records un one table (a field for the
letter, and the other for the numeric part).
Otherwise, having a table for each site will be enough, as Jimmy suggests.
Andrés G. Montañez
Zend Certified Engineer
Montevideo - Uruguay
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php