Re: mysql_fetch_array to associative array

On Mon, 2007-07-16 at 10:52 -0400, Robert Cummings wrote: > On Mon, 2007-07-16 at 07:41 -0700, Andras Kende wrote: > > Hello, > > > > I use the following GetArray for returning an array from mysql results. > > > > But having a hard time modifying it for returning a simple associative array > > > > Like: > > > > $conn->GetAssoc('SELECT id, name from manufacturers') > > > > Array ( [2] => BMW [1] => MAZDA [9] => FORD ) > > > > > > function GetArray($query) { > > $get = $this->Execute ( $query ); > > > $result = array(); > > while ( $row = mysql_fetch_array($get) ) { > $result[] = $row; > > } > > mysql_free_result($get); > > > > return $result; > > } > > > > > > function GetAssoc($query) { > > $get = $this->Execute ( $query ); > > > $result = array(); > > while ( $row = mysql_fetch_array($get) ) { You should probably use mysql_fetch_assoc() in the above line. Cheers, Rob. -- ........................................................... SwarmBuy.com - http://www.swarmbuy.com Leveraging the buying power of the masses! ...........................................................