I ended up with having some logic in my View ! need help

Code:

function ser()





 {





  $data = array (

  'register' => 'register_view',

  'options' => 'options_view',

  'search' => 'search',

  'ser' => 'ser_view',  // my view file.

  'script' => 'example_script');

  

  

  $this->load->view('include/query', $data);

 }

Code:

<div id="content_main">

 <div id="content">

 &lt;?php

 $s = $this->input->GET('job_name');

 $c = $this->input->GET('city');

     $this->db->select('*');

  $this->db->select_avg('SALARY');

  $this->db->select_avg('BOUNS');

  $this->db->from('main_records');

  $this->db->where('JOB_NAME',$this->input->GET('job_name'));

  

  if($this->input->GET('city')!='all') {

    $this->db->where('CITY_NAME',$this->input->GET('city'));

 }

 $this->db->where('approval',1);

  

  $this->db->join('the_cities', 'the_cities.ID_CITY = main_records.CITY','left');

  $this->db->join('categories', 'categories.idCATEGORIES = main_records.CATE','left');

  $this->db->join('experience', 'experience.idEXPERIENCE = main_records.EXPERIEANCE','left');

  $this->db->group_by('CITY');

  if($this->input->GET('sort')=='lowest') {

  $this->db->order_by('SALARY','asc');

  } else if ($this->input->GET('sort')=='highest') {

   $this->db->order_by('SALARY','desc');

  }

  $this->db->group_by('EXPERIEANCE');

  $q = $this->db->get();

   

   if($q->result()==NULL) {

   echo "No result";

  }

   

   if ($this->input->GET('job_name')) {

   foreach($q->result() as $row){

  $t = $row->SALARY+$row->BOUNS;

   echo $row->JOB_NAME." ";

   echo $row->CITY_NAME." ";

   $exp = $row->EXPERIEANCE;

        echo " ".$row->PERIOD.br(2);

 



  }

 }

 

  

  ?&gt;



 </div>

</div>