Geolocation with IP2Location

HI,

I’m trying to redirect user from one specific country to one html page and the rest to other html. I’m using with IP2Location.

The problem that I have is with PHP code.
I get this message error: “ip2country Query Failed” and I don’t get redirect.

Any help will be really appreciated.

Line that show the error:

<?php
	// Execute SQL query 
$result = mysql_query($query) or die("ip2country Query Failed"); 

?>

My DB name:extremm8_ip2country
the Table is:ip2country
User:8_admin
Pass:4Lobo

This is all the script:

<?php 
// Replace this MYSQL server variables with actual configuration 
$mysql_server = "localhost"; 
$mysql_user_name = "8_admin"; 
$mysql_user_pass = "4Lobo"; 

// Retrieve visitor IP address from server variable REMOTE_ADDR 
$ipaddress = getenv(REMOTE_ADDR); 

// Convert IP address to IP number for querying database
$ipno = Dot2LongIP($ipaddress); 

// Connect to the database server 
$link = mysql_connect($mysql_server, $mysql_user_name, $mysql_user_pass) or die("Could not connect to MySQL database"); 

// Connect to the IP2Location database 
mysql_select_db("extremm8_ip2country") or die("Could not select database"); 

// SQL query string to match the recordset that the IP number fall between the valid range 
$query = "SELECT * FROM IPCountry WHERE $ipno < = ipTO AND $ipno>=ipFROM"; 

// Execute SQL query 
$result = mysql_query($query) or die("ip2country Query Failed"); 

// Retrieve the recordset (only one) 
$row = mysql_fetch_object($result); 

// Keep the country information into two different variables 
$countrySHORT = $row->countrySHORT; 
$countryLONG = $row->countryLONG; 

// Free recordset and close database connection 
mysql_free_result($result); mysql_close($link); 

// If the visitors are from JP, redirect them to JP site 
if ($countrySHORT == "CN") 
{
  Header("Location: http://www.google.co.jp"); 
} else { 
// Otherwise, redirect them to US site 
  Header("Location: http://www.google.com");
}
exit;

// Function to convert IP address (xxx.xxx.xxx.xxx) to IP number (0 to 256^4-1) 
function Dot2LongIP ($IPaddr) { 
 if ($IPaddr == "") 
 {
   return 0;
 } else { 
   $ips = split ("\.", "$IPaddr"); 
   return ($ips[3] + $ips[2] * 256 + $ips[1] * 256 * 256 + $ips[0] * 256 * 256 * 256); 
 }
} 
?>