[Resolved] SQL query detail

[MrCool]

I have a sql query from which i ask to retrieve the values from the table. And now i want to change the $row to $news[0] (beeing 0 the news' id). How can I do that without having to set each one case by case?

while ($row = mysql_fetch_object ($res))
{
$news=array();
$news[$row['id']]=$row;
} 
mysql_free_result ($res);

This doesn't work

[sidney]

you are fetching an object not an array

http://uk.php.net/manual/en/function.mysql-fetch-object.php

);

 $news=array();
while ($row = mysql_fetch_object ($res)) 
{ 
$news[$row->id]=$row; 
}  

mysql_free_result ($res); 

or use mysql_fetch_assoc

 $news=array();
while ($row = mysql_fetch_assoc ($res)) 
{ 
$news[$row['id']]=$row; 
}  

mysql_free_result ($res);