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]
