- 论坛徽章:
- 0
|
$sql = "select ip_num from ips ";
$query = mysql_query($sql) or die("Invalid query: " . mysql_error());;
while ($row=mysql_fetch_row($query))
{
$reg_ip = $row[0];
$q = "SELECT region_name FROM `ip_group_city` where `ip_start` can't connect DB! %s \n",
mysql_error());
}
?>
desc ips;
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| reg_ip | varchar(18) | YES | MUL | NULL | |
| city_name | varchar(50) | YES | MUL | NULL | |
| ip_num | bigint(16) | YES | MUL | NULL | |
+-----------+-------------+------+-----+---------+-------+
desc ip_group_city;
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| ip_start | bigint(20) | NO | PRI | | |
| country_code | varchar(2) | NO | | | |
| country_name | varchar(64) | NO | | | |
| region_code | varchar(2) | NO | | | |
| region_name | varchar(64) | NO | | | |
| city | varchar(64) | NO | | | |
| zipcode | varchar(6) | NO | | | |
| latitude | float | NO | | | |
| longitude | float | NO | | | |
| timezone | varchar(4) | NO | | | |
| gmtOffset | varchar(4) | NO | | | |
| dstOffset | varchar(4) | NO | | | |
+--------------+-------------+------+-----+---------+-------+
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u2/61329/showart_2074672.html |
|