Build a multidimensional associative array from an array. Simple, but caught me out for a moment.

multi_assoc_array_from_array.php

<?php

// Declare new array
$fieldsarrsql = array();

// Loop through origional array
foreach ($origarray as $fieldsarr) {
// Populate new array with associated data
 $fieldsarrsql[] = array(
 'tablealias'=>$fieldsarr['tablealias'], 
 'columnname'=>$fieldsarr['columnname'],
 'columnalias'=>$fieldsarr['fieldname']
 );
}

var_dump($fieldsarrsql);
?>

array
  0 => 
    array
      'tablealias' => string 'u' (length=1)
      'columnname' => string 'first_name' (length=10)
      'columnalias' => string 'first_name' (length=10)
  1 => 
    array
      'tablealias' => string 'u' (length=1)
      'columnname' => string 'last_name' (length=9)
      'columnalias' => string 'last_name' (length=9)