[eluser]Paleleaves[/eluser]
Hi,
I've a model. Pls see the code below
Code:
<?php
class Articles_model extends Model
{
function Articles_model()
{
parent::Model();
$this->load->database();
}
function list_participants($num, $offset)
{
$query = $this->db->get('property', $num, $offset);
return $query;
}
}
?>
It's working fine but I need pass multiple tables in the place of 'property' in my model. see the code below.
Code:
SELECT * FROM property, district, ptype WHERE property.reqType = ptype.pID AND property.districtName = district.dID
Anybody can help me to modify my model using this query. thanks