hi any help appreciated. i have a mysql database table with 3 fields - province, province_id & country_id.the table contains 4 records. i want to get the data from the database and put into an array. i would then later want to read the data from the array. this is what i used to create the array: $provinces = array ("province" => array ("province_id" => $row['province_id'],"province" => $row['province'],"country_id" => $row['country_id'])); i then create a drop-down menu which is in the same while loop as that creating the array: $value = $provinces["province"]["province"]; echo '<option value="',$value,'">',$value,'</option>\n'; the drop down menu displays fine - listing the 4 provinces but if i do a count of the array it only lists a count of 1. what am i doing wrong and how can i make sure that all the records from the mysql database are included in the array even if i keep adding records to the mysql table. then how do i extract the data from the array - especially how do i do a search for a particular record within the array? thanks in advance clive