I was just wondering how i would be able to code perform an SQL query and then place each row into a new array, for example, lets say a table looked like the following:

$people= mysql_query("SELECT * FROM friends")    

Output:

| ID | Name | Age |   
--1----tom----32   
--2----dan----22   
--3----pat----52   
--4----nik----32   
--5----dre----65

How could i create a multidimensional array that works in the following way, the first rows second column data could be accessed using $people[0][1] and fifth rows third column could be accessed using $people[4][2].

How would i go about constructing this type of array?

Sorry if this is a strange question, its just that i am new to PHP+SQL and would like to know how to directly access data. Performance and speed is not a issue as i am just writing small test scripts to get to grips with the language.