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]

Reply via email to