Site Query Error

Rewrite your query like this:

PHP Code:

$sql = "SELECT hall_review.id,hall.name,hall_review.review,hall_review.review_by,hall_review.rating FROM hall_review JOIN hall ON hall.id = hall_review.hall_id JOIN accounts ON hall.created_by = accounts.accountId WHERE accounts.accountId = $id AND hall_review.status = 0 ORDER BY hall_review.hall_id"; 


Or use CI's query builder class:

PHP Code:

$this->db
->select('hr.id,hr.name,hr.review,hr.review_by,hr.review_rating')
->from('hall_review hr')
->join('hall h','h.id = hr.id')
->join('accounts a','h.created_by = a.accountId')
->where('a.accountId',$id)
->where('hr.status',0)
->order_by('hr.hall_id');
$query = $this->db->get();
if ($query->num_rows() == 0) return FALSE;
return ($query->result();