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]
