Re: Storing IP blocks

2008-06-12 Thread Jim Lyons
For whatever it's worth, some years ago I wrote a database that kept track of IPs. I found it very easy if I treated the IPs as numbers. Each IP is a quartet of digits, each in the range 0-255. This really means an IP is a 4-digit number in base 256 and you can use use standard conversion functi

Storing IP blocks

2008-06-12 Thread Scusting
Hi, I need to be able to store data from our Radius servers that includes IP addressing and IP blocks into a MySQL field that is easily searchable. Basic IP addreses I have sorted with INET_ATON(), but is there a way to store blocks of IP's as in "192.168.1.0/24" in a way that would allow it