hi,
no the both sollutions won't work cause:
I can't sort within a query cause subnetaddr is a varchar ("10.10.10.10")
so it will be ordere like this
10.10.10.10
100.10.10.10
60.10.10.10
and that's not good cause 60 is smaller as 100, so with the function
ip2long() i will first make an integer of it
the second array solution you gave, won't work, cause I need ALL the query
results in the array, and that's the problem I can't handle....
if I would do it like you said, I can sort it, but then I have a sorted
array and for each element I have to do a query again to get the other
fields of the table, and that's not good (2500 rows)
so can please still somebody help me with this?
-----Original Message-----
From: Becoming Digital [mailto:subs@becomingdigital.com]
Sent: dinsdag 10 juni 2003 15:42
To: php-db@lists.php.net
Subject: 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: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
