[Resolved] natsort?

dreams4000

Hey all,

Does anyone know of a way to natsort() something like this, either in mysql or php? A lot of the items in $name below are numbers and need to sort naturally.

			$sqlCAT = "select id, name from ".$tableCollab["tctest"]." where sub_category_id='" . $myrowCOM[0] . "' order by name";
			$resultCAT = mysql_query($sqlCAT, $conn);

		while ($myrowCAT = mysql_fetch_row($resultCAT)) //loop through all 			
{


							$tc_number = stripTree($myrowCAT[0]);
			                                $name = stripTree($myrowCAT[1]);
								echo "['<font color=gray>".$name."</font>','../test/viewtest.php?restriction=NoHeader']\n\n,";

}

since $name is outputing one line at a time just looping thru all the names, I can't get natsort to work as there is nothing to sort but one at a time. Any ideas either doing this via the sql call, or some way to put natsort in so the names are like 1. name 2.name 3. name instead of 1.name 2.name 20.name 3.name 30.name etc.

Installer

Make an array, then sort it.

$name = array();
while ($myrowCAT = mysql_fetch_row($resultCAT)) { 
    $tc_number = stripTree($myrowCAT[0]); 
    $name[] = stripTree($myrowCAT[1]); 
}
natsort($name);
foreach ($name as $value) {
    echo "['<font color=gray>" . $value . "</font>','../etc']\n\n,";
}

dreams4000

Well that works, for part of it, it sorts the numbers, but I need $tc_number to still loop like it was, (i didnt have it in the above example) but the url has that variable in it and part of the url changes based on the $tc_num.. now that it isnt looping, it doesn't display each one. kinda like:

echo "['<font color=gray>".$name."</font>','../test/viewtest.php?restriction=NoHeader&tc_num=$tc_num']\n\n,";

Any ideas?

Installer

Since it wasn't in your example, I guess I didn't see it. Sorry.

dreams4000

I know🙂 I am sorry. Do you have any idea how to do that?

Installer

Try this:

$name = array();
$tc_number = array(); 
while ($myrowCAT = mysql_fetch_row($resultCAT)) {  

    $tc_number[] = stripTree($myrowCAT[0]);  

    $name[] = stripTree($myrowCAT[1]);  

} 
natsort($name); 
foreach ($name as $key => $value) { 
    echo "[" . $value . "','../etc?tc=" . $tc_number[$key] . "],"; 
}

Since "natsort" maintains index associations, that should work. (The echo statement is shortened for clarity.)

dreams4000

That works, Thanks so much!!