note 104829 added to function.mysql-fetch-array

Here is an example of assigning keys and values from database columns: Database name: "table_name" --------------------------------------------- | some_data | other_data | --------------------------------------------- | 5 | frank | --------------------------------------------- | 11 | dan | --------------------------------------------- | 23 | christopher | ---------------------------------------------- $result = mysql_query("SELECT some_data, other_data FROM table_name"); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $arr[$row["some_data"]] = $row["other_data"]; } mysql_free_result($result); RESULT: Array ( [5] => frank [11] => dan [23 ] => christopher ) ---- Server IP: 69.147.83.197 Probable Submitter: 71.209.238.133 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-fetch-array.php Edit -- https://master.php.net/note/edit/104829 Del: integrated -- https://master.php.net/note/delete/104829/integrated Del: useless -- https://master.php.net/note/delete/104829/useless Del: bad code -- https://master.php.net/note/delete/104829/bad+code Del: spam -- https://master.php.net/note/delete/104829/spam Del: non-english -- https://master.php.net/note/delete/104829/non-english Del: in docs -- https://master.php.net/note/delete/104829/in+docs Del: other reasons-- https://master.php.net/note/delete/104829 Reject -- https://master.php.net/note/reject/104829 Search -- https://master.php.net/manage/user-notes.php