Geocoding datafeed/web searches for concert ticket site

Discussion in 'Programming' started by rickdini, Feb 7, 2009.

0
  1. #1
    Hi everybody,

    I'm developing an affiliate ticket website, and I'd like to have it set up like this: the user enters location and the my site returns results closest to him. I'm not quite sure how to do this. The datafeed has city and state information for each event. Any ideas how to get started?

    Thanks,
    Rick
     
    rickdini, Feb 7, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    does your datafeed have a mysql db?
     
    crivion, Feb 7, 2009 IP
  3. rickdini

    rickdini Peon

    Messages:
    26
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I do have a MySQL and a script that will load the datafeed into the MySQL db. The ticket datafeed has City and State information.
     
    rickdini, Feb 7, 2009 IP
  4. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #4
    well just insert a where statement into the query like
    select * from tableName where city = '$inputOfCity'
     
    crivion, Feb 7, 2009 IP