Assigning variable in associative array?

[Anon]

I already known how to print out an associative array but how about assigning variables into the associative array? For inctance in database
Member Sponsor
1. 001 none
2. 002 001
3. 003 001
4. 004 002
5. 005 002

select member from table where sponsor = 001

then how can i assign this data into an associative array
$array = array ($sponsor => array ($member));

thank you for your assistance.

(if this example is not convenient please use any example that is suitable as long as it is related to assigning variable into ass.array)

[Anon]

first of all you have to fetch the data out of the database. When working with mysql u can do something like this:
// connect to db
mysql_connect($whateverhost,$user,$password);
// store query in result
$result = mysql_db_query("whateverdb","select * from table where sponser = '001' ");
// store elements in ass. array
while($row = mysql_fetch_array($result))
$array = array("member" => $row["member"], "sponsor" => $row["sponsor"]);