public static function get_auto_complete_list() { $table_name = Model_Project::table(); $sql = <<<SQL SELECT name FROM {$table_name} ORDER BY name ASC SQL; $result = \Fuel\Core\DB::query($sql)->execute(); $auto_complete_list = array(); foreach ($result->as_array() as $index => $array) { foreach ($array as $project_name) { $auto_complete_list[] = $project_name; } } return $auto_complete_list; }