Re: [PHP-DB] Select statement drops 10th digit during table lookup?

[Ronan Chilvers]

Here's how I did it when playing with this...

Table definition:-

CREATE TABLE ip_list (
  ip_from double default NULL,
  ip_to double default NULL,
  country_code char(2) default NULL,
  country_name varchar(100) default NULL,
  KEY ip_from (ip_from,ip_to,country_code,country_name)
) TYPE=MyISAM;

Basic code to query it (takes a parameter 'ip' as GET paramter):-
<?php
        /*
                IP Lookup script
                        * prints a country code and name for an ip in the $_GET array
        */

        //Vars & Constants
        define("HOST","myhost");
        define("USER","myuser");
        define("PASS","mypassword");
        define("DB","ips");
        define("IP",$_GET["ip"]);

        // Functions
        function dbconnect() {
                if (($conn=mysql_pconnect(HOST,USER,PASS))===false) {
                        die("Couldn't connect to server");
                }
                if (!mysql_select_db(DB,$conn)) {
                        die("Couldn't select database");
                }
                return $conn;
        }
        function dbclose($conn) {
                if (!mysql_close($conn)) {
                        die("Couldn't close database connection");
                }
                return true;
        }
        function dosql($SQL) {
                if (($result=mysql_query($SQL))===false) {
                        die("Couldn't do sql : $SQL");
                }
                return $result;
        }

        //Core
        $SQL = "SELECT COUNTRY_NAME AS cn, COUNTRY_CODE AS cc FROM ips.ip_list WHERE 
IP_NUM BETWEEN ip_from AND ip_to";

        $conn = dbconnect();

        $ip = "127.0.0.1";

        $QSQL = str_replace("IP_NUM",sprintf("%u",ip2long(IP)),$SQL);
        
        $result = dosql($QSQL);
        $data = mysql_fetch_array($result);

        echo "ip:".IP."<BR>";
        echo "cn:".$data["cn"]."<BR>";
        echo "cc:".$data["cc"];

        dbclose($conn);
?>

HTH !!

Ronan
e: [EMAIL PROTECTED]
t: 01903 739 997
w: www.thelittledot.com

The Little Dot is a partnership of
Ronan Chilvers and Giles Webberley

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php