Sorting IP addr's

[Munci]

Hi all,
I built a form to pull from a mysql DB a list of currently assigned IP's to servers we have at work, but if I try to display them sorted by IP, it looks like:
172.25.100.1
172.25.100.10
172.25.100.11
172.25.100.2
172.25.100.22
172.25.100.3
...

When I display the data, how would I sort these so they look like:
172.25.100.1
172.25.100.2
172.25.100.3
...
172.25.100.10
...

I know this is basic, sry 🙁

I looked around for past postings but didn't see anything.
Thanks for any assistance.

M

[AstroTeg]

If it was me, I'd use [man]ip2long[/man] and save that value in the database. Then you can use your order by as you'd expect it to work (all the IPs in the proper order). Then for the output, you use [man]long2ip[/man] to convert the number back to the standard dotted format.

By storing the numeric value in the database, you can do some cool stuff with subnets and ranges really easily as well.

[Munci]

very interesting, never thought of that! I'll give it a try, thanks for the tip 🙂