Login

01-28-2012, 05:45 PM

[eluser]ibnclaudius[/eluser]
I have two tables that have fields with the same name, how can I select each one?

Code:
$data['get_subjects'] = $this->mb_database->get_subjects($this->session->userdata('school_id'));

Code:
public function get_subjects($school_id)

 {

  $query = $this->db->select('*')->from($this->subjects_table, $this->classes_table)->join($this->classes_table, $this->classes_table . '.id = ' . $this->subjects_table . '.classes_id', 'INNER')->where($this->classes_table . '.id', $school_id)->get();

  if ($query->num_rows > 0)

  {

   return $query;

  }

  else

  {

   return FALSE;

  }

 }

Code:
&lt;?php foreach($get_subjects->result_array() as $row) : ?&gt;

     <p>nome: &lt;?php echo $row['name']?&gt;</p><br />

    &lt;?php endforeach; ?&gt;

For example, when I do the foreach, it always return the name from $this->classes_table