newb: how do I get an array with mysql_fetch_array

[ckey]

I have the following script:

<?
mysql_connect ('localhost', 'test', 'test');
mysql_select_db ('fonts_images');

$result = mysql_query ("SELECT * FROM fonts_images");
$rows = mysql_num_rows ($result);
echo "bild=";
while ($list = mysql_fetch_array ($result))
{
$id = $list["image_id"] ;
$cat = $list["cat_id"] ;
$image = $list["image_media_file"] ;
$thumb = $list["image_thumb_file"] ;
$name = $list["image_name"] ;
}

// my problem is that i want to get an array which values I can adress with i.e.

echo $list[thumb];

?>

at the moment there doesnt happen anything. I think I have to use something with new Array and replace echo $list[thumb]; with echo $my_array[thumb]; but I dont know how.

thanks in advance. ckey

[ahundiak]

Not sure of your question but:

If you want to do
$list['thumb'] instead of $list['image_thumb_file'] then use an alias in your sql query

"Select
image_thumb_file as thumb,
image_media_file as media,
(rest of the colmns)
from fonts_images"

If you want an array of all the records then do
while($list[] = mysql_fetch_array($result));

$id_record3 = $list[3]['image_id'];