Mixing assoc arrays and rows

[Anon]

I have a multi-dimensional array that is return from a MySQL query. This is the code that put the results into the array.

for ($i = 0; $i < $news_numrows; $i++)
{
for ($j = 0; $j < db_num_fields ($news_query_result); $j++)
{
$temp_array[$i][$j] = $temp_row[$j];
}
}

Now, I want to references variables in the array like this:

echo $temp_array[4]["some_field_name"];

However, I'm finding that it's not working too well. Anyone have any ideas?

[Anon]

You could just say (assuming that $news_query_result is the resultset from the query)

for($i=0; $i<$news_numrows; ++$i)
{ $temp_array[$i] = mysql_fetch_assoc($news_query_array);
}

Or use that while() loop:

while($row=mysql_fetch_assoc($news_query_array))
{ $temp_array[]=$row;
}