builder an one array from mysql querys

[ben_g]

I have several mysql querys and would like to build an array in php to store the information.

Each query returns a PlayerID and one peice of data about that player.

what I would like is an array like;
new array (PlayerID, data1, data2, data3)

I am not all the experienced using arrays but all I need is a basic idea of how to get data from one array to another while using PlayerID as a way of putting the data in the correct place in the new array.

Also if anyone knows a website that describes how to use temporary tables in mysql could you please let me know. As this could be a simpler way of solving my problem.

Thanx for your help,

Ben.

[Weedpacket]

Gotta be brief, I'm 'fraid:

$sql="select playerid, data1,data2,data3 from mytable";
$result=mysql_query($sql);
$player_array=array();
while($row=mysql_fetch_assoc($result))
{
	$playerid=$row['playerid'];
	$data1=$row['data1'];
	$data2=$row['data2'];
	$data3=$row['data3'];
	$player_array[$playerid]=array(
		'data1'=>$data1,
		'data2'=>$data2,
		'data3'=>$data3);
}

All the data is in $player_array. $player_array['foo'] is an array that
contains' foo's data. $player_array['foo']['data1'] is foo's data1
(whatever that is).