Multidimensional Array's Experimenting

[jmaccs64]

I am experimenting (learning) how to use multidimensional array's, I am trying to load search results in a multidimensional array. I think I am on the right track, but I seem to have a block with using foreach to assign the array...

Here is what I have so far:

<?
$search_param="smith";

// The SQL statement below could return multiple results, if for example $search_param="smith";

$sql="SELECT  student_id, first_name, last_name, grad_year FROM students WHERE first_name LIKE '%" . $search_param .  "%' OR last_name LIKE '%" . $search_param ."%'"; 

$result=mysql_query($sql);
$students=mysql_fetch_assoc($result);
echo"<br />";
$result_array = array($students[student_id] => array("first_name" => $students[first_name], "last_name" => $students[last_name], "grad_year" => $students[grad_year], "student_id" => $students[student_id]																
																				)

);



//Just some testing to see what comes out...							
echo $result_array[13407][first_name];
echo "<br />";
echo $result_array[13407][last_name];
echo "<br />";
echo $result_array[13407][grad_year];
echo "<br />";


 ?>

And here is what I would like to end up with:

Array ( [13407] => Array([first_name] => john 
                         [last_name] => smith 
                         [grad_year] => 2012 ),

    [48794] => Array([first_name] => mike 
                      [last_name] => smith 
                     [grad_year] => 2010 )

	)

Thanks in advance!

[dagon]

while ($row = mysql_fetch_assoc($result))
{ 
$out[$row[student_id]]=array('first_name'=>$row[first_name],'last_name'=>$row[last_name],'grad_year'=>$row[grad_year]);
}


print_r($out);