On Thu, Dec 04, 2003 at 09:53:16AM -0600, Rankin, Randy wrote:

> I have a form which captures US addresses ( address, city, state ) and
> telephone numbers ( 10 digit ) and am writing this data to a MySQL table. I
> need to expand this to capture non-US info, so I was hoping for some
> guidance on forms and table structures. I have googled this to death and
> still haven't come up with anything. 

I tend to use an internationalized format for all phone numbers, such as:

+CCC (NP)AAAXXXXXXX

where:
CCC = country code (i.e. 44 for UK, 39 for Italy, etc)
NP = optional national prefix (e.g. in the US this is 1)
AAA = area code (212 for New York, 6 for Rome, etc)
XXXXXXX = actual phone number

-- 
Aj.
Sys. Admin / Developer

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to