adding data to an array from a result set?

[tomdelonge]

So, i'm not great with arrays...

 

I need this prototype:

 

$data = array(

'$row->id' => '$row->name'

);

 

So, I would presume I need to loop over the result set and add each new line to the old array. How do I do that?

[Zane]

while($row = mysql_fetch_array($query)) {
     $data[$row['id']] = $row['name']
}

[fooDigi]

you could do something similar to this...

 

$array = array();
while($row = mysql_fetch_array($mysql_result)) {
  $array[$row['id']] = $row['name'];
}

 

edit: oops, i see zanus has already posted the same...