如何根据年份和月份选择所有数据

我想根据用户选择的年和月来选择数据。但是结果没有显示正确的输出。它只是显示数据库中所有数据的列表。

有人可以帮我修复我的代码吗

看法

  <div class="large-3  columns ">
  <?php echo form_open("announcement/announcement_result");?>
  <?php echo form_dropdown('m', $m, set_value('m'), 'id="m"'); ?>
  <?php echo form_dropdown('q', $q, set_value('q'), 'id="q"'); ?>
  <?php echo form_submit('search', 'SEARCH', 'class="button expand"'); ?>
  <?php echo form_close(); ?>
  </div>

控制器

function announcement_list() 
{

  $q = '';
  $data['q'] = $q;

  $this->data['q'] = array(
    '' => ' Select Year',);   

  for ($i = 0; $i < 10; $i++)
    {
    $date = date('Y') - $i;
    $data['q'][$date] = $date; 
    }

  $m = '';
    $data['m'] = $m;

    $data['m'] = array(
        '' => 'Select Month',
    );
    for ($m = 1; $m <= 12; $m++) {
        $month = date("F", mktime(0, 0, 0, $m));
        $data['m'][$month] = $month;
    }

        $data['results'] = $this->news_model->get_announcement_list($config['per_page'], $page);
    }

    public function announcement_result($q='default', $m='default') 
{

    if ($q == '') $q = $this->input->post('q');
    $this->data['q'] = $q;

    if ($q == '') redirect(base_url().'announcement/announcement_list');

    $q = '';
  $data['q'] = $q;

  $this->data['q'] = array(
    '' => ' Select Year',);   

  for ($i = 0; $i < 10; $i++)
    {
    $date = date('Y') - $i;
    $data['q'][$date] = $date; 
    }

  $m = '';
    $data['m'] = $m;

    $data['m'] = array(
        '' => 'Select Month',
    );
    for ($m = 1; $m <= 12; $m++) {
        $month = date("F", mktime(0, 0, 0, $m));
        $data['m'][$month] = $month;
    }

        $data['results'] = $this->news_model->get_results($m, $q, $limit=6, $offset=0); 
    }

模型

   function get_results($m ='default', $q='default', $limit, $offset)
{
    $sql = "SELECT *
        FROM ArkibBerita
        WHERE code='PENGUMUMAN' AND Enable = 'Y' AND Lang ='EN' AND BeritaDate LIKE '%$q%' 
        ORDER BY position ASC
        OFFSET {$offset} ROWS
        FETCH NEXT {$limit} ROWS ONlY";
        $query = $this->db->query($sql);
        return $query->result();

}