return an associative array

[NoBullMan]

Hi,
I am trying to return an associative array and I am not sure if I am doing this right. I do get the results from my query, but assigning it to the array does not seem to be correct:

$x = (1,2,3,4);
$someid = 1;
$ret = array();
$ids = explode(",", $x);

foreach($ids as $id) {
  $query = "SELECT Items.Name, Options.OptionNumber 
         FROM Items INNER JOIN Options ON Items.ItemID = Options.ItemID WHERE (((Items.ItemID)=$id) AND ((Options.ID)=$someid));";
      $result = @mysql_query($query);
      $result = @mysql_fetch_array($result);

  $ret[$result['OptionNumber']]['Name'] = $result['Name'];
}
return $ret;

I want ot retrun an array that looks like:
ret[1234]="name1"
ret[7654]="name2"
ret[1789]="name3"

where 1234, 7654 and 1789 are OptionNumber and name1, name2 and name3 are their respective names.

Thanx.

[azunoman]

I use a function on all my db reads:

I do the query: (generally in a function), it then calls another function to set up the array. Hope this helps.

function get_some_data(..)
{
$query = "SELECT * FROM some_table WHERE something='something'";
$result = @($query);
if (!$result)
return false;
$num_rows = @mysql_num_rows($result);
if ($num_rows==0)
{
return false;
}else{
$result = db_result_to_array($result);
}
return $result;
}

function db_result_to_array($result)  

{     

$res_array = array();       

for ($count=0; $row = @mysql_fetch_array($result); $count++)       

    $res_array[$count] = $row;     

return $res_array;  }