Matt, this is not a direct answer to your question, more a tip on how you design your database: You should avoid storing the same information twice. You only risk inconsistencies. In your case I suggest you compute the textual ID from the primary key value using the PHP sprintf function whenever you need it, e.g sprintf ( "CR %03d", $primaryKey ). sprintf is the function to use for the type of number to text conversion you are looking for.
--- Geir Pedersen http://www.activio.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php