Associative Array Sort Problem

[Matt_Parsons]

I cant figure out why my code just refuses to output a sorted array. This is my code

$chosenlist = array(array("Liam Bowden","7","Forward"),
array("Rob Gwilliam","4","Midfield"),
array("Steve Bowgen","9","Defence"),
array("Matthew Parsons","2","Goalie") );

$count = Count($chosenlist);
for ($row =0; $row < $count; $row++)
{
$cnt2 = $cnt++;
echo ("<table width=\"300\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">");
for ($column = 0; $column < 3; $column++)
{
if ($column == 1)
{
$goals=$chosenlist[$row][$column];
echo ("<td width=\"65\">$goals</td>");
}
elseif ($column == 2)
{
$position=$chosenlist[$row][$column];
echo ("<td width=\"85\">$position</td></tr>");
}
else
{
$playername=$chosenlist[$row][$column];
echo ("<tr><td>$playername</td>");
}
}
echo ("</table>");
$cnt=$cnt+2;
$i++;
}

[bad76]

Hi,
but where you sort it?

Try to use some like arsort () function...

[Matt_Parsons]

damn, left that bit out when copying and pasting onto this board.
I was using
ksort($chosenlist)

have also tried asort and arsort.

[bad76]

Originally posted by Matt Parsons
damn, left that bit out when copying and pasting onto this board.

I know you tell it! 🙂

The problem is the column you want order... by name? by number?...

Chosen one, you have to change your array $chosenlist to this:

Sort by name:
$chosenlist["Liam Bowden"] = array("Liam Bowden","7","Forward");
$chosenlist["Rob Gwilliam"]=array("Rob Gwilliam","4","Midfield"),;
$chosenlist["Steve Bowgen"]=array("Steve Bowgen","9","Defence");
$chosenlist["Matthew Parsons"]=array("Matthew Parsons","2","Goalie");

sort by number:
$chosenlist["7"] = array("Liam Bowden","7","Forward");
$chosenlist["4"]=array("Rob Gwilliam","4","Midfield"),;
$chosenlist["9"]=array("Steve Bowgen","9","Defence");
$chosenlist["2"]=array("Matthew Parsons","2","Goalie");

then just:
asort($chosenlist); reset($chosenlist);

I hope this help.

(clearless:
$chosenlist = array("7"=>array("Liam Bowden","7","Forward"),
"4"=>array("Rob Gwilliam","4","Midfield"),
"9"=>array("Steve Bowgen","9","Defence"),
"2"=>array("Matthew Parsons","2","Goalie") );
)

[Weedpacket]

array_multisort() is available, but that's probably a bit overelaborate. usort() will allow you to sort your array (which, as bad76 noted, isn't associative) by whatever criterion you like. (Example 2 on that page; to sort by name in your case you'd compare the [0] elements.)

But to turn your array into an associative one, either go with bad76's suggestion of using the names as keys (in which case it might be an idea to drop the name from among the array values to prevent possible confusion), or have an array of associative arrays like
array(
array('name'=>"Liam Bowden", "number=>"7", "position"=>"Forward"),
...
);

[Matt_Parsons]

Thanks for the help so far. It looks a sensible option.
But when i tried using it i get no output at all even though count says that the array has value: this is my code.

$chosenlist["Liam Bowden"] = array("7","Forward");
$chosenlist["Rob Gwilliam"]=array("4","Midfield");
$chosenlist["Steve Bowgen"]=array("9","Defence");
$chosenlist["Matthew Parsons"]=array("2","Goalie");

arsort($chosenlist);
reset($chosenlist);
$count = Count($chosenlist);

for ($row =0; $row < $count; $row++)
{
echo ("<table width=\"300\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">");
for ($column = 0; $column < 3; $column++)
{
if ($column == 1)
{
$goals=$chosenlist[$row][$column];
echo ("<td width=\"65\">Goals:$goals</td>");
}
elseif ($column == 2)
{
$position=$chosenlist[$row][$column];
echo ("<td width=\"85\">Position:$position</td></tr>");
}
else
{
$playername=$chosenlist[$row][$column];
echo ("<tr><td>Name:$playername</td>");
}
}
echo ("</table>");
}

also tried outputting it like this:
$count = Count($chosenlist);
for ($row =0; $row < $count; $row++)
{
for ($column = 0; $column < 3; $column++)
{
echo $chosenlist[$row][$column];
}
echo '<br>';
}

but still no luck.
Thanks for all help

[bad76]

Originally posted by Matt Parsons

...
$chosenlist["Liam Bowden"] = array("7","Forward");
...

is $chosenlist["Liam Bowden"] = array("Liam Bowden","7","Forward"); ...don't remove the name from second array, you need it twice...