Problems setting up a Database on 1and1 Linux server

[Barand]

there's no data!

[Barand]

I created an addition table

 

country

  code

  name

 

You need to convert the IP to an integer value with that data then

 

 

$sql = "SELECT c.name, l.city, l.latitude, l.longitude
        FROM blocks b
        INNER JOIN location l USING (locId)
        INNER JOIN country c ON l.country = c.code
        WHERE $ipInt BETWEEN b.startIpNum AND endIpNum";