Re: [PHP] State and City Database
On Fri, Jul 9, 2010 at 5:37 PM, Thijs Lensselink thijs.lenssel...@strawberries.nl wrote: On 07/07/2010 10:02 PM, tedd wrote: Hi gang: Does anyone have a source for a US State and City database? if some one need ip-location service.. try it here.. http://ceynet.asia/api/geo.php?ip=8.8.8.8 hope to open the geo api soon for free/public use. ~viraj Cheers, tedd Hey Tedd, Maybe this helps. I used the data files for some other projects.. http://earth-info.nga.mil/gns/html/ http://geonames.usgs.gov/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] State and City Database
At 3:14 PM -0700 7/9/10, Tommy Pham wrote: Looking at your source, shouldn't be 'onChange' instead of 'onClick' for the selects? Tommy: You are absolutely right and you saved me a lot of work. Thanks, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] State and City Database
On 07/07/2010 10:02 PM, tedd wrote: Hi gang: Does anyone have a source for a US State and City database? Cheers, tedd Hey Tedd, Maybe this helps. I used the data files for some other projects.. http://earth-info.nga.mil/gns/html/ http://geonames.usgs.gov/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] State and City Database
On Fri, Jul 09, 2010 at 10:43:09AM -0400, tedd wrote: snip Here's an example of my copy working: http://php1.net/b/zipcode-states/index.php Problem: the city and state select drop-downs won't stay dropped for me, and won't accept anything but Lansing, Michigan. They don't drop down long enough for me to select anything else. Zip drop down appears to work okay. Paul -- Paul M. Foster -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] State and City Database
Paul M Foster wrote: On Fri, Jul 09, 2010 at 10:43:09AM -0400, tedd wrote: snip Here's an example of my copy working: http://php1.net/b/zipcode-states/index.php Problem: the city and state select drop-downs won't stay dropped for me, and won't accept anything but Lansing, Michigan. They don't drop down long enough for me to select anything else. Zip drop down appears to work okay. Paul Similar issue here too. But I can at least select a state (if I'm quick) and then when I click on the city, the list blinks and then deletes the contents of the state and zip code dropdown menus. System: Windows XP SP3 + FF v3.5.3 w/Firebug Checking with my Opera 9.24 install, seems to do something similar. Timer is very fast and it doesn't allow for me to click on anything. -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] State and City Database
On Jul 9, 2010, at 1:58 PM, Jim Lucas wrote: Paul M Foster wrote: On Fri, Jul 09, 2010 at 10:43:09AM -0400, tedd wrote: snip Here's an example of my copy working: http://php1.net/b/zipcode-states/index.php Problem: the city and state select drop-downs won't stay dropped for me, and won't accept anything but Lansing, Michigan. They don't drop down long enough for me to select anything else. Zip drop down appears to work okay. Paul Similar issue here too. But I can at least select a state (if I'm quick) and then when I click on the city, the list blinks and then deletes the contents of the state and zip code dropdown menus. System: Windows XP SP3 + FF v3.5.3 w/Firebug Checking with my Opera 9.24 install, seems to do something similar. Timer is very fast and it doesn't allow for me to click on anything. -- Jim Lucas I tried it in Safari and it works just fine. Take care, Floyd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] State and City Database
Floyd Resler wrote: On Jul 9, 2010, at 1:58 PM, Jim Lucas wrote: Paul M Foster wrote: On Fri, Jul 09, 2010 at 10:43:09AM -0400, tedd wrote: snip Here's an example of my copy working: http://php1.net/b/zipcode-states/index.php Problem: the city and state select drop-downs won't stay dropped for me, and won't accept anything but Lansing, Michigan. They don't drop down long enough for me to select anything else. Zip drop down appears to work okay. Paul Similar issue here too. But I can at least select a state (if I'm quick) and then when I click on the city, the list blinks and then deletes the contents of the state and zip code dropdown menus. System: Windows XP SP3 + FF v3.5.3 w/Firebug Checking with my Opera 9.24 install, seems to do something similar. Timer is very fast and it doesn't allow for me to click on anything. -- Jim Lucas I tried it in Safari and it works just fine. Take care, Floyd Just for giggles, I downloaded and installed Safari just now v5.0 (7533.16) and tried it. The page is non functional. The drop down menus exist, but when I select the state in the state list, it doesn't update the city list or zip code list. And when I change the city, it doesn't update the zip code field. -- Jim Lucas A: Maybe because some people are too annoyed by top-posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] State and City Database
On Jul 9, 2010, at 2:32 PM, Jim Lucas wrote: Floyd Resler wrote: On Jul 9, 2010, at 1:58 PM, Jim Lucas wrote: Paul M Foster wrote: On Fri, Jul 09, 2010 at 10:43:09AM -0400, tedd wrote: snip Here's an example of my copy working: http://php1.net/b/zipcode-states/index.php Problem: the city and state select drop-downs won't stay dropped for me, and won't accept anything but Lansing, Michigan. They don't drop down long enough for me to select anything else. Zip drop down appears to work okay. Paul Similar issue here too. But I can at least select a state (if I'm quick) and then when I click on the city, the list blinks and then deletes the contents of the state and zip code dropdown menus. System: Windows XP SP3 + FF v3.5.3 w/Firebug Checking with my Opera 9.24 install, seems to do something similar. Timer is very fast and it doesn't allow for me to click on anything. -- Jim Lucas I tried it in Safari and it works just fine. Take care, Floyd Just for giggles, I downloaded and installed Safari just now v5.0 (7533.16) and tried it. The page is non functional. The drop down menus exist, but when I select the state in the state list, it doesn't update the city list or zip code list. And when I change the city, it doesn't update the zip code field. -- Jim Lucas That's weird. I just tried again just to make sure I wasn't seeing things. I selected Indiana and the city list populated with the cities from Indiana. I then chose Indianapolis and the zip codes list populated with Indianapolis zip codes. I'm using Safari 5 on the Mac. I just tried in in Firefox 3.6.6 on my Mac and experienced the same thing you did - the state drop-down doesn't stay opened. Really kind of odd, isn't it?! Take care, Floyd -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] State and City Database
To all: http://php1.net/b/zipcode-states/index.php I have not tried the state/city/zip demo with any other than the Safari browser. It works for that browser. Sorry, I should have checked it out via other browsers before introducing it to the list. I will work on it. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] State and City Database
-Original Message- From: tedd [mailto:tedd.sperl...@gmail.com] Sent: Friday, July 09, 2010 12:17 PM To: PHP Subject: Re: [PHP] State and City Database To all: http://php1.net/b/zipcode-states/index.php I have not tried the state/city/zip demo with any other than the Safari browser. It works for that browser. Sorry, I should have checked it out via other browsers before introducing it to the list. I will work on it. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Tedd, Looking at your source, shouldn't be 'onChange' instead of 'onClick' for the selects? Regards, Tommy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] State and City Database
-Original Message- From: Tommy Pham [mailto:tommy...@gmail.com] Sent: Friday, July 09, 2010 3:15 PM To: 'PHP' Subject: RE: [PHP] State and City Database -Original Message- From: tedd [mailto:tedd.sperl...@gmail.com] Sent: Friday, July 09, 2010 12:17 PM To: PHP Subject: Re: [PHP] State and City Database To all: http://php1.net/b/zipcode-states/index.php I have not tried the state/city/zip demo with any other than the Safari browser. It works for that browser. Sorry, I should have checked it out via other browsers before introducing it to the list. I will work on it. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com Tedd, Looking at your source, shouldn't be 'onChange' instead of 'onClick' for the selects? Regards, Tommy Sorry, force of habit camel case... :) I meant 'onchange' instead of 'onclick'. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] State and City Database
On Jul 9, 2010, at 10:43 AM, tedd wrote: At 2:07 PM +0200 7/9/10, Thijs Lensselink wrote: On 07/07/2010 10:02 PM, tedd wrote: Hi gang: Does anyone have a source for a US State and City database? Cheers, tedd Hey Tedd, Maybe this helps. I used the data files for some other projects.. http://earth-info.nga.mil/gns/html/ http://geonames.usgs.gov/ LOL Did you look at the name of the Executive Secretary on that page? Being dyslexic, I immediately read You Lost, which seemed ironic for the USGS. I know I asked in my post for US State and City database and did not mention zip codes, but that was something I was after as well. Strangely enough, the USGS states that it's the U.S. Census Bureau who keeps the zip codes. But the U.S. Census Bureau says it's the US Postal Service and the US Postal Service points to private businesses such as: http://www.zip-codes.com/ I was almost certain that the UP Postal Service had something, but I couldn't find it. I'm not sure where I got my current database, but I think I'll just stick with it and allow the client to get a subscription for an update (if they want). Hey tedd, the US Postal Service does control the Zip Codes... The reason you couldn't get anything out of them is they do not publicly sell or give that data out to anyone except for a few private businesses who resell it... One of the best/cheapest sources I've found for mailing lists (it includes the actual delivery address plus the city, state, zip) is melissadata.com. Although it's not free nor exactly what you asked for they may be able to point you in a better direction to get exactly what you want. If you need any additional help let me know. My day job is working directly with the post office and mailing lists :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] State and City Database
Hi gang: Does anyone have a source for a US State and City database? Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] State and City Database
Does anyone have a source for a US State and City database? This is a monster but seems to contain what you need: http://www.geonames.org/. Marc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php