Re: 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 <jaski@satyam.net.in> 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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/