Robert, The original posting's project is cataloging the states from countries all over the world not just the US. In this case, he needs a numeric ID as I don't think the USPS keeps a list of state abbreviations for other countries. Otherwise, I would agree with you. ;-)
Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Robert A. Rosenberg" To: [EMAIL PROTECTED] <[EMAIL PROTECTED] cc: > Fax to: Subject: Re: How do you deal with URL's? 06/22/2004 05:09 PM At 22:38 -0300 on 06/21/2004, Sergio Salvi wrote about Re: How do you deal with URL's?: >Separate data from how it's displayed. I mean, create a table called >"states" with the fields "state_id", "state_name" and "state_url". Put >the data in the according field: > >state_id state_name state_url >1 Alabama http://www.alabama.gov >2 Washington http://access.wa.gov >...and so on Instead of a auto_increment state_id, go with the USPS 2 letter code (AL, WA, etc). That way you can pull up the state name from an address. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]