Re: Creating alphanumeric id for a table

> 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. If you're thinking of retrieving the newest value of an AUTO_INCREMENT column, immediately after inserting a row, there are different ways to do this depending on how you're connecting to MySQL. PDO, for example, has a method called lastInsertId(): http://us2.php.net/manual/en/pdo.lastinsertid.php And the mysql_* family of functions has mysql_insert_id(), etc. Ben