Snijders, Mark wrote:
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
() )
- compare successively item by item
HTH
Ignatius
_
- Original Message -
From: "Snijders, Mark" <[EMAIL PROTECTED]>
To: "'Becoming Digital'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 8:33 A
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:[EMAIL PROTECTED]
Sent: dinsdag 10 juni 2003 15:42
To: [EMAIL PROTECTED]
Subject: Re: [
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.
You can subsequently sort the array for the desired r
hi,
you can add the ip2long() function into your SELECT statement and have
an ORDER BY clause at the end like this...
SELECT s_id, subnet_name, ip2long('subnetaddr'), subnetmask,dnsdomain,
location, contact, ccn FROM subnets ORDER BY subnetaddrr;
hope it helps.
KD
On Tue, 10 Jun 2003, Snijders