[Resolved] Need help with USort...

busyguy78

Hi everyone...!

I need some help figuring out this Usort thing...

I have a multidimensional array like this...


$output[$i][0]='ID'
$output[$i][1]='First'
$output[$i][2]='Last'
$output[$i][3]='Age'

When I display it in a table I get this...

1 Joe Blow 25
2 Jane Doe 5
3 Jimmy Chu 23
4 Paul Pile 30

I want it to be like this...

4 Paul Pile 30

1 Joe Blow 25
3 Jimmy Chu 23
2 Jane Doe 5

After the array is loaded I am sorting it using the following code...


// Function for sorting the new array...

function cmp ($a,$b)  
{  
  // the [3] is the column I am sorting by
  $cmp = strcmp($a[3],$b[3]); 
  return $cmp ? $cmp : -1; 
}

// Now let's see if this function works...

// $output is the array I am sorting
usort($output,"cmp");

What I get is this...

3 Jimmy Chu 23
1 Joe Blow 25
4 Paul Pile 30
2 Jane Doe 5

How can I get this to sort the 'Age' column as numbers...?

Also, I need it in DESC not ASC...

Any help would be awesome...!!!

busyguy78

Ok...
Got this to work...
I'll stick in all of the code for the page in case it will help anyone...


<?

// Hit up DB...

include("dbConnect.php");

// Set up query...

$results = mysql_query("SELECT * FROM apartments");

// Establish how many rows were returned...
	$totalrows = mysql_num_rows($results);


// Start moving rows through loop...

if($myrow = mysql_fetch_array($results))
{

	$i = 0;


	do
	{

		// Set outside variable
		$var = "work";

		// Load information from query and new variable into array
		$output[$i][0] = $i;
		$output[$i][1] = $myrow['AptID'];
		$output[$i][2] = $myrow['AptAddress'];
		$output[$i][3] = $myrow['AptApt'];
		$output[$i][4] = $myrow['AptCity'];


		if($i<$totalrows)
		{
			$i = ($i+1);
		}

	}

	while ($myrow = mysql_fetch_array($results));	

}

else

{

	echo "Sorry Charlie";

}


// Let's put this in a visible table...


echo "Results";

echo "<table>";
echo "<tr>
		<td>
			Match
		</td>
		<td>
			ID
		</td>
		<td>
			Address
		</td>
		<td>
			Apt
		</td>
		<td>
			City
		</td>
	</tr>";

// Sort array desc

 rsort($output);	


// Send array through the output loop thing

if (count($output) > 0)
{
	for ( $i = 0; $i < count($output); $i++ )
	{
		echo "<tr>";
		echo "<td>";
		echo $output[$i][0];
		echo "</td><td>";
		echo $output[$i][1];
		echo "</td><td>";
		echo $output[$i][2];
		echo "</td><td>";
		echo $output[$i][3];
		echo "</td><td>";
		echo $output[$i][4];
		echo "</td></tr>";
	}

}

else

{

	echo "Move along, nothing to see here";

}



?>

I moved the Match column from the last spot to the first... This got it to sort the array by the row I wanted automatically...

I then found the rsort function at PHP.net... This is how I got it to sort desc...

Hope this helps someone...!