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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.