grege Posted November 16, 2010 Share Posted November 16, 2010 Hey Guys, So I have a zip code database with 40,000 some entries... and I am reading a query and returning it and need it to store it in array similar to this snippet of code . $cities = array( array('city'=>'New York', 'state'=>'NY', 'zip'=>'10001'), array('city'=>'Los Angeles', 'state'=>'CA', 'zip'=>'90001'), array('city'=>'Chicago', 'state'=>'IL', 'zip'=>'60601'), array('city'=>'Houston', 'state'=>'TX', 'zip'=>'77001'), array('city'=>'Phoenix', 'state'=>'AZ', 'zip'=>'85001'), array('city'=>'Philadelphia', 'state'=>'PA', 'zip'=>'19019'), array('city'=>'San Antonio', 'state'=>'TX', 'zip'=>'78201'), array('city'=>'Dallas', 'state'=>'TX', 'zip'=>'75201'), array('city'=>'San Diego', 'state'=>'CA', 'zip'=>'92101'), array('city'=>'San Jose', 'state'=>'CA', 'zip'=>'95101'), array('city'=>'Detroit', 'state'=>'MI', 'zip'=>'48201'), array('city'=>'San Francisco', 'state'=>'CA', 'zip'=>'94101'), array('city'=>'Jacksonville', 'state'=>'FL', 'zip'=>'32099'), array('city'=>'Indianapolis', 'state'=>'IN', 'zip'=>'46201'), array('city'=>'Austin', 'state'=>'TX', 'zip'=>'73301'), array('city'=>'Columbus', 'state'=>'OH', 'zip'=>'43085'), array('city'=>'Fort Worth', 'state'=>'TX', 'zip'=>'76101'), array('city'=>'Charlotte', 'state'=>'NC', 'zip'=>'28201'), array('city'=>'Memphis', 'state'=>'TN', 'zip'=>'37501'), array('city'=>'Baltimore', 'state'=>'MD', 'zip'=>'21201'), ); Here is the code I currently have... But it is not being stored into an array, it is just a mysqli_result object with the correct amount of num_rows, and fields. $cities = $zip->getAllZipCityState(); function getAllZipCityState() { // Get ALL Zip / City / State $query = 'SELECT ' . $this->dbZip . ', ' . $this->dbCity . ', ' . $this->dbState . ' '; $query.= 'FROM ' . $this->dbTable . ' '; //$qry = mysql_query($query,$this->db); $qry = $this->db->query($query); if(!$qry){ echo "MySql Error #".mysqli_errno($this->db).': '.mysqli_error($this->db).'<br>'; die; } //return mysqli_fetch_array($qry); return $qry; } Thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.