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: [PHP-DB] array fill/sort question
I might be overlooking
() )
- 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 AM
Subject: RE: [PHP-DB] array fill/sort question
hi
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
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
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,
Digital
www.becomingdigital.com
- Original Message -
From: Snijders, Mark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
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
