1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Searching By City Name

Discussion in 'Databases' started by rzvagelsky, Oct 19, 2006.

0
  1. #1
    Hey everyone.

    I am currently using php to search a zip code database and display results by radius. Lately I have been considering a "search by city name" feature as well. I do have some general ideas on how to go about it, but I would like know if someone has a proven method of integrating the feature.

    I appreciate any feedback.
     
    rzvagelsky, Oct 19, 2006 IP
  2. JEET

    JEET Notable Member

    Messages:
    3,825
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #2
    If your zip code database has city names, then it's just 1 query.

    SELECT * FROM $zipdb WHERE city='$city';

    Where $city is the city name entered by the searcher, and $zipdb is the table name.

    Alternatively, you can also use:
    SELECT * FROM $zipdb WHERE city LIKE '%$city%';

    which will probably output more general results, depending on what is being searched for...

    Hope that helps you.
    Bye :)
     
    JEET, Oct 19, 2006 IP
    rzvagelsky likes this.