need help formating JSON

[eluser]bretticus[/eluser]
Your json code shows each result as an associative array within a larger array. Just format accordingly:

Code:

function get_location_list()
        {
            $location_list = array('results' => array());
            
            $query = $this->db->query('SELECT id, location FROM location');
            
            foreach ($query->result_array() as $row)
            {
                $value = $row['id'];
                $text = $row['location'];
                $location_list['results'][] = array('id' => $value, 'name' => $text);
            }
            echo json_encode($location_list);
            
            //return ;
                                        
        }