Need sql query dump for geo database

Discussion in 'Databases' started by osmasters, Nov 11, 2010.

0
  1. #1
    Hi dp,

    I want to have one database which can help me to get timezone by User's Ip.

    Please help me to find this database.

    I am searching in geonames but its seems text database, i dont know how to import it so i need in sql format.
     
    osmasters, Nov 11, 2010 IP
  2. xwwwx

    xwwwx Greenhorn

    Messages:
    56
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    18
    #2
    You shouldn't be looking for that, what you need to do it have a database with country(or city) and its timezone, then you use GeoIP to get the country(or city) of the ip, and you get the timezone that way.
     
    xwwwx, Nov 16, 2010 IP
  3. mustaineoz

    mustaineoz Active Member

    Messages:
    326
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    58
    #3
    so he needs a db for that!
     
    mustaineoz, Nov 18, 2010 IP
  4. greenoro0

    greenoro0 Active Member

    Messages:
    435
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    70
    #4
    Osmasters can you explain in detail? what exactly did you required?
     
    greenoro0, Dec 13, 2010 IP