array sorting help

[cdxrevvved]

Ok.. Pulling a query from a mysql database

it pulls this string from a single cell

mainmenu,L,Mx,1,search,L,Mx,2,recomus,L,Mx,3,randqt,L,Mx,4,pgnplls,L,Mx,5,spotlt,L,Mx,6,

This is in the format of -

module name, module column, module status, module position.

Now, Im exploding it into an array with where $result->moduleslt is the string above...

$xltresult=explode(",", $result->moduleslt);

Now, I need to sort it by module position, aka, the numbers above from 1-6...

Whats the best way and how can I do this?

Should I change it into a multidimensional array and then try doing a sort on it that way? or is there some other way to do this. And fyi, I cannot easily change the database structure to make it any easier. Gotta be a string like above...

Help please!!!

[cdxrevvved]

Nm.. Found this in another post after searching and searching...

function array_csort(&$arr, $column=0, $order='asc') {
  $order = ($order == 'asc') ? SORT_ASC : SORT_DESC;  

  foreach ($arr as $a) {
    $keys = array_keys($a);
    $sortarr[] = $a[$keys[$column]];
  }
  array_multisort(&$sortarr, $order, &$arr, $order);
} // array_csort

Does EXACTLY what I needed... Now, anyone know how to trim off whitespace in an array? The methods im using just arent working.

NM again.... Its amazing how removing an extra comma at the end of the string fixes things... {grin}