RE: [PHP-DB] Zip Code Fields

Doesn't the USPS have some online API for checking Zip Codes? Not sure but I thought I read about it somewhere. look here http://www.usps.com/webtools/ -----Original Message----- From: Justin Palmer <justin@cetusa.org> Sent: Sep 8, 2004 12:25 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] Zip Code Fields Are you only accepting US zip codes? Justin -----Original Message----- From: Aaron Todd [mailto:aaloki88@hotmail.com] Sent: Wednesday, September 08, 2004 8:36 AM To: php-db@lists.php.net Subject: [PHP-DB] Zip Code Fields Just curious, but what kind of field is everyone using to store a Zip Code. I set mine to Medium Integer with a max of 5 digits, but for zip codes that begins with 0 the 0 is knocked off. The only solutiuon I can think of is to make the field a text field. Does anyone have a better solution? Thanks, Aaron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php DDDDD JJJJJJJJ BBBBB DDD DD JJJJJJJJ BBB BB DDD DD JJJ BBB BB DDD DD JJJ BBB BB DDD DD JJJ BBBBB DDD DD JJ JJJ BBB BB DDD DD JJ JJJ BBB BB DDD DD ..JJJJJJ ..BBB BB DDDDD .. JJJJ ..BBBBB ----------------------------------- Dylan Barber (CIW Professional, A+ Technician) Web Designer / Developer / DotNetNuke Portal Creator ----------------------------------- Clip those URLs! - Short links are easier to remember. http://clipurl.com DDDDD JJJJJJJJ BBBBB DDD DD JJJJJJJJ BBB BB DDD DD JJJ BBB BB DDD DD JJJ BBB BB DDD DD JJJ BBBBB DDD DD JJ JJJ BBB BB DDD DD JJ JJJ BBB BB DDD DD ..JJJJJJ ..BBB BB DDDDD .. JJJJ ..BBBBB ----------------------------------- Dylan Barber (CIW Professional, A+ Technician) Web Designer / Developer / DotNetNuke Portal Creator ----------------------------------- Clip those URLs! - Short links are easier to remember. http://clipurl.com