Re: [PHP-DB] cites/states data
Hi Again, I am building a simple php page which has this functionality. 1)It asks user to select his/her country 2)Then Select State 3)Then Select City For the above functionality I have built a MySQL Table which has these fields place_id , parent_id, place_name place_id is a autoincrement primary key parent_id is the place_id of the place which is one level above the current place ie. for a city it will be its parent state and for state it will be its parent country. Now functionality part is all well and working .. but I feel daunted by the task of building the mysql table and would not like to build the table by hand .. searching and adding states and cities one by one .. So is there any solution to this problem. I thought because there is such a functionality on so many sites out there .. there must be some place where I can find the data. It could be an XML file or any other form which I can utilize to feed my table. Thanks for any pointers. Regards Jaskirat At 08:34 AM 6/30/01 -0700, you wrote: Don't know that this will give you what you want, but it may be useful later. It deals with pulling zip codes from the USPS.com site Use IE's Web Browser Control to Extract Data From a Web Site http://www.inquiry.com/techtips/web_pro/10min/10min1199/10min1199.asp Good luck, olinux --- Jaskirat [EMAIL PROTECTED] wrote: Hello all, I am creating a database driven php page for which I need to have a database of US and Canadian states and cities in the back end. Is there some place on the web where I can get such data in the reusable form and I can feed my MySQL tables with that. Right now the only option I have is to add each state/city manually which I guess will be a tedious re-inventing the wheel exercise. Some kind of xml file etc if any one knows about .. or has will be great TIA Jaskirat -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] cites/states data
Hello all, I am creating a database driven php page for which I need to have a database of US and Canadian states and cities in the back end. Is there some place on the web where I can get such data in the reusable form and I can feed my MySQL tables with that. Right now the only option I have is to add each state/city manually which I guess will be a tedious re-inventing the wheel exercise. Some kind of xml file etc if any one knows about .. or has will be great TIA Jaskirat -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] cites/states data
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Jaskirat) wrote: I am creating a database driven php page for which I need to have a database of US and Canadian states and cities in the back end. Is there some place on the web where I can get such data in the reusable form and You might try looking at census data. It's public info, so free, and should have extensive lists of city info somewhere (you may have to cobble together a complete list from various regional sub-lists, but then again maybe not...). Another possible source: public GIS (geographic information system) databanks. See http://directory.google.com/Top/Science/Social_Sciences/Geography/Geographi c_Information_Systems/Data/, for instance. There are also plenty of people willing to sell you such info... ;-) -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] cites/states data
Hello all, I am creating a database driven php page for which I need to have a database of US and Canadian states and cities in the back end. Is there some place on the web where I can get such data in the reusable form and I can feed my MySQL tables with that. Right now the only option I have is to add each state/city manually which I guess will be a tedious re-inventing the wheel exercise. Some kind of xml file etc if any one knows about .. or has will be great TIA Jaskirat -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] cites/states data
It's public info, so free, and Hah! Try to get the 9-digit ZIP code stuff. Developed with tax dollars and sold by (I believe) a private corporation. Isn't it great that we're not getting all of the government we're paying for? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]