no the both sollutions won't work cause:

I can't sort within a query cause subnetaddr is a varchar ("")

so it will be ordere like this

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:[EMAIL PROTECTED]
Sent: dinsdag 10 juni 2003 15:42
Subject: Re: [PHP-DB] 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

----- Original Message ----- 
From: "Snijders, Mark" <[EMAIL PROTECTED]>
Sent: Tuesday, 10 June, 2003 08:55
Subject: [PHP-DB] array fill/sort question


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 :  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

Reply via email to