building - How do I populate and associative array using php and mysql -
how add elements below array? /// build cross reference array parent company names of subcategories/// $newarray = array(); $comp_names = "select company_name, company_id pe_company_access"; $name_results = mysql_query($comp_names, $dbcnx); while ($row5 = mysql_fetch_assoc($name_results)) { $newarray = array($row5["company_id"] => $row5["company_name"]); } print_r($newarray); thanks, george i say, should go with: while ($row5 = mysql_fetch_assoc($name_results)) { $newarray[$row5["company_id"]] = $row5["company_name"]; } that way have company_id key of associative array, , company_name value. if want have sub arrays, indexed 0 based index, need following: while ($row5 = mysql_fetch_assoc($name_results)) { $newarray[] = array($row5["company_id"] => $row5["company_name"]); }