Quick question! Multiple tables

[eluser]Paleleaves[/eluser]
Hi,

thanks for the help. But it didn't work at all. I've changed the <Model> like below.

Code:

<?php
class Articles_model extends Model
{
  function Articles_model()
  {
      parent::Model();
      $this->load->database();
  }
  
function list_participants($num, $offset)
  {
      

$query = $this->db->join('SELECT * FROM property, district, ptype WHERE property.reqType = ptype.pID AND property.districtName = district.dID', $num, $offset);
      return $query;
  }
}
?>

I spent many hours to correct this issue and tried different methods! :red: