Re: Query table / results to an array

Ron Piggott wrote:

I need help populating an array based on the output of a mysql query. $reference_number is a value assigned by auto_increment $description is what I want the value of the array to be --- a few words in length $reference_number = mysql_result($search_result,$i,"reference_number"); $description = mysql_result($search_result,$i,"description");

$references = array(); $result = "select id, description from table"; while ($row = mysql_fetch_assoc($result)) { $references[$row['id']] = htmlentities($row['description'], ENT_QUOTES, 'ISO-8859-1'); } print_r($references); -- Postgresql & php tutorials http://www.designmagick.com/