[Resolved] sorting an array with another array

vaaaska

This seems to be a little advanced for me as I can't completely wrap my head around how to approach this.

I have an array that is an order of things:

array(23,54,1,45,12,9)

And then I have an array of values from the table. Within this array is an id which relates to the previous array. It holds quite alot of information so I'm hoping there might be an easy way, as opposed to the long and messy way, to sort this array with the values in the other array.

Looking through the array functions, I can't quite see it. Any advice on this one?

Sorry, I don't have any code produced on this...I'm trying to fish for a technique here if that's ok. Thanks...

devinemke

spool the data coming from the database into an array with the ID's as the keys and then do something like:

$array = array(
1 => 'one',
9 => 'nine',
12 => 'twelve',
23 => 'twenty three',
45 => 'forty five',
54 => 'fifty four'
);

$array_order = array(23,54,1,45,12,9);

foreach ($array_order as $value)
{
	echo $array[$value] . '<br>';
}

vaaaska

That's basically the route I was going before I posted...the difficulty I'm having is trying to get my data out of the arrays. It appears though that there is another bug in the system because I'm getting some really eratic results. Guess I need to just stick with this approach...

Thanks for the advice...helps alot to hear this...v

vaaaska

Actually, brain fart. I wasn't spooling my table results with their id's as the keys...now I get it...

foreach ($results as $new) {

  $new_results[$new['id']] = ;  //whatever is needed here...

}