[Resolved] result sets, arrays and sorting

[kenhess]

I do a: SELECT * FROM SERVERS;

I get a result set,

I then do a:

while ($row = mysql_fetch_array($result)) {
$id = $row['ID'];
$server = $row['Name'];

$list .= "<p>$server</p>";

but the $list shows the $server in order they were entered into the table....using an ORDER BY Name ASC in the query yields an alphanumeric sort order, but I am wanting a natsort for Name.

Does anyone know how to do this and where I would put this in my code? I have tried making an array out of my result set, natsorting it, then imploding back to a result set, but I must have something wrong in the separator because I get the error that it is not a proper mysql result set.

thanks,

[LordShryku]

Same thing you're doing, just with an array

$array=array();
while ($row = mysql_fetch_array($result)) { 
   $array[] = $row['Name']; 
}
natsort($array);
$array = "<p>".implode("</p><p>",$array)."</p>";

[kenhess]

Thanks,

I see the logic in what you are doing and that was the missing piece for me, but now the question is...do I change my result set to an array to get $array, because now I get no output.

Sorry, there must be dust on my brain today.

[LordShryku]

All you should need to do after that is echo $array. You get nothing from that?

[kenhess]

DOH!!!!

Thanks. Sorry about that.