Create Array from mysql result

[oracle259]

How do i create an array from a mysql result. So far i have tried this

while ($res = mysql_fetch_array($result, MYSQL_BOTH) {

$link[] = $res[item];

}

echo $link[];

but that doesnt seem to work.

any help would be appreciated.

[Barand]

instead of echo $link, you need to loop thru the array
[code]
foreach ($link as $item) echo $item.'<br/>';
[/code]

[Gaoshan]

The array is created automatically by mysql_fetch_array. To step through that array just use:
[code]while ($row = mysql_fetch_array($result)) {
    echo $row[0], $row[1], $row[2]; 
}[/code]