Need to create an array and sort by keys

[Clark]

Hi, I have 2 variables created from the result of a mysql query.

For each row there is a scalar $state and $number. I need to be able to push them into an array, say $States, and sort it by $number. I would like to arrange them in descending order with the state with the highest number being first.

What is happening though is they are going into an array, but as one long element instead of seperate items and their keys.

Here is my code:

while ($row = mysql_fetch_row($result)) {
	$state = $row[0];
	$number = $row[1];
	$States = array($state=>$number);


arsort($States);
reset($States);

$HowMany = count($States);
print "Number of elements = $HowMany\n";

[killerbishop]

The problem is that your assigning new array elements to $States. What you mean to do is:

$States = array();

while ($row = mysql_fetch_row($result)) {
    $States[$row[0]] = $row[1];
}

arsort($States);

$HowMany = count($States);
print "Number of elements = $HowMany\n";

print_r($States);

[Clark]

This works, and very well I might add. Thank you. 🙂

Now to study up and figure out how and why it works.