Posted by Me on 09/13/05 18:03

I'm using php and mysql for an "application" site for users at our clinic.
The problem I'm having (and I have no clue how to do it) is that I'd like
users to enter a zipcode into a field, then have that auto magically pop up
the city, county and state of that zipcode (I don't have to worry about
zipcodes in seoarate counties as we only need to use a database containing
our local areas.)

Right now I just have it set for users to manually enter zip, city, county
and state, but some use all caps and some don't, some spell cities wrong,
etc. I was thinking of making a mysql query in php, but that wouldn't
refresh the current page, and I'd like the page to be one form (instead of
using iframes and multiple forms they'd have to submit.) AJAX looks
interesting, but I'm not very familiar with Javascript (if at all.)

So, I'm hoping there is a script, or something similiar that I could use as
a template, or at least learn from, where I could replace part of the code
on the page so the user would only need to type in the zipcode to retrieve
city, county and state information.

Of course, after populating the fields with the correct information, the
user could finish the form and submit it.

It sounds like a simple thing (although I'm sure it isn't), but I'm not too
familiar with Javascript, and I searched google and have yet to see it
addressed (although I've seen similiar problems posted in various
newsgroups.) Could someone just point me in the right direction? This
newsgroup seemed to have pretty cool people from the posts I read, so I
thought I'd look for help here. Thanks in advance.

[Back to original message]