CodeIgniter's get() method doesn't receive WHERE conditions as expected
10:07 20 Dec 2013

I have gone through many questions about joining 3 tables in Codeigniter, but I am stuck in these lines of coding that includes returning products array.

function products_sorter($region)
{
    $this->db->select('*');
    $this->db->from('wiyo_products');
    $this->db->join('wiyo_products_distribution', 'wiyo_products.id = wiyo_products_distribution.product_id');
    $this->db->join('wiyo_regions', 'wiyo_regions.id = wiyo_products_distribution.region_id');
    $query = $this->db->get(array('wiyo_regions.slug' => $region));
    
    if ($query->num_rows() > 0) {
        return $query;
    }
}

But I am getting error which look like this

A Database Error Occurred

Error Number: 1103

Incorrect table name ') JOIN '

SELECT * FROM (`wiyo_products`, `) JOIN `wiyo_products_distribution` ON `wiyo_products`.`id` = `wiyo_products_distribution`.`product_id` JOIN `wiyo_regions` ON `wiyo_regions`.`id` = `wiyo_products_distribution`.`region_id`

What sort of error is this? How to solve this?

php mysql codeigniter where-clause query-builder