MiCR0 Posted May 13, 2008 Share Posted May 13, 2008 I have run into a Big problem with searching for a range on an IP address via MySQL. MySQL `IP_Address` int(11) unsigned NOT NULL, All of the IP's are written by IP2long() all seems to be working however when trying to search for an IP range I just can not work out why this is not working. SELECT IP_Address FROM IPS WHERE IP_Address > $startlong AND IP_Address < $endlong Linux 64 Bit System so it should not go into negative numbers any idea what is wrong please anyone? Link to comment https://forums.phpfreaks.com/topic/105474-searching-ranges-for-an-ip-address-with-in-mysql/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.