rendered paste body$sql_find = "select distinct entries.router,INET_NTOA(entries.route),entries.mask,entries.route_type,INET_NTOA(entries.dstip),entries.metric,names.name,names.netid,entries.time from entries INNER JOIN names ON names.dstip = entries.dstip where entries.route <= INET_ATON('$rt') and entries.route_end >= INET_ATON('$rt') and route_type like '%ospf%'";
mysql> desc entries;
+------------+-------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------------+------+-----+---------+-------+
| router | varchar(100) | YES | | NULL | |
| route_type | varchar(10) | YES | | NULL | |
| route | int(100) unsigned | YES | | NULL | |
| route_end | int(100) unsigned | YES | | NULL | |
| mask | int(11) | YES | | NULL | |
| ad | int(11) | YES | | NULL | |
| metric | int(11) | YES | | NULL | |
| dstip | int(100) unsigned | YES | | NULL | |
| time | varchar(50) | YES | | NULL | |
| interface | varchar(75) | YES | | NULL | |
+------------+-------------------+------+-----+---------+-------+
10 rows in set (0.00 sec)
mysql> desc names;
+-------+-------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------------+------+-----+---------+-------+
| name | varchar(75) | YES | | NULL | |
| dstip | int(100) unsigned | YES | | NULL | |
| netid | int(100) unsigned | YES | | NULL | |
+-------+-------------------+------+-----+---------+-------+
3 rows in set (0.00 sec)