Jump to content

Sorting number values with php/mysql


landysaccount

Recommended Posts

Hello,

 

I have a table with ip values:

 

172.16.100.10

172.16.100.11

.....

172.16.100.50

172.16.100.51

....

172.16.100.100

172.16.100.102

172.16.100.103

 

and so on....

 

I would like to get a list in ascending order:

 

The ip_address field is a varchar(15);

 

select ip_address as ip from ip where ip_assigned='N' order by ip limit 5;

 

but I get:

 

172.16.100.10

172.16.100.100

172.16.100.101

172.16.100.102

172.16.100.103

 

How can I get a real sort in mysql?

 

Thanks in advaced.

Link to comment
https://forums.phpfreaks.com/topic/175229-sorting-number-values-with-phpmysql/
Share on other sites

  • 2 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.