Re: array fill/sort question

I might be overlooking something, but can't you just do this? $query = "SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain, location, contact, ccn FROM subnets ORDER BY subnetaddr"; If you can't, you can sort the array like this. <? $query = "SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain, location, contact, ccn FROM subnets"; $results = mysql_query( $query ); while ( $iptable = mysql_fetch_array( $result ) ) { $iptable['subnetaddr'] = ip2long( $iptable['subnetaddr'] ); } ?> You can subsequently sort the array for the desired result. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Snijders, Mark" <Mark.Snijders@atosorigin.com> To: <php-db@lists.php.net> Sent: Tuesday, 10 June, 2003 08:55 Subject: [PHP-DB] array fill/sort question hi, I'm working on a ipaddres/subnet programm now i have a talbe with a lot of information about ip-addresses i'm having this query: SELECT s_id, subnet_name,subnetaddr,subnetmask,dnsdomain, location, contact, ccn FROM subnets the subnetaddr field looks like this : 100.20.20.1 and is ofcourse a varchar field BUT before displaying it on the screen i have to sort it by subnetaddr and then show it but i have to sort it as integer, so i use the php-function ip2long(); so you get a decimal... so what i have to do: do the query> make a decimal field of the 'subnetaddr' put it in an array, sort it and display it BUT how can i put ALL of the fields in the query in an array, sort it, and then display it? please help me, I can't work it out :( thanks, Mark