[Resolved] mysql->multi array or better solution?

[skeetley]

I am brand new to working with mysql and php and need some help to tackle my problem.

This is how I have come up with a way to do this.
I want to select * from the table which I can do. But then I want to read this into my php as a multi-dimensional array. Reason being is that I want to have the whole table so I can query for each row and store each cell as a variable.

For example, say my table has 3 fields and contains 3 records.
Fields: Name, Size, Colour

Alpha, 12, Blue
Beta, 34, Red
Gamma, 45, Green

I want to read in this table and then make $AplphaSize=12, $AlphaColour=Blue, $BetaSize=34 and so on. Now I can do all this in PHP if I can figure out how to read that database query in as a MD array. Please point me in how I would do this unless someone has a better solution?

[devinemke]

working from your example and assuming that "Name" is the primary key field:

$array = array ();

$result = mysql_query ('SELECT * FROM table_name');
while ($row = mysql_fetch_assoc ($result))
{
	extract ($row);
	$array[$Name] = array ('Size' => $Size, 'Colour' => $Colour);
}

print_r ($array);

now you can refer to elements like this:

echo $array['Alpha']['Size']; // outputs "12"
echo $array['Beta']['Color']; // outputs "Red"

[superwormy]

while ($array = mysql_fetch_array ($result))
{

$multi_array[] = $array;

}

print_r ($multi_array);

[skeetley]

Thank you, thank you, thank you. devinemke your code was an even better idea than I had and saves me a bunch of work. Thanks again.