[eluser]jt66250[/eluser]
I changed this code:
function retrieve_practice_areas($language = 'en')
{
$this->db->select('title_' . $language . ' as title, title_escaped_' . $language . ' as title_escaped' );
$this->db->where('section_id', 1);
$this->db->orderby('title_' . $language, 'ASC');
$query = $this->db->get('content_pages');
$rows = $query->result();
return $rows;
}
to this code: (changes are bolded)
function retrieve_practice_areas($language = 'en')
{
$this->db->select('title_' . $language . ' as title, title_escaped_' . $language . ' as title_escaped' );
$this->db->where('section_id', 1
. 'viewable', 0);
$this->db->orderby('title_' . $language, 'ASC');
$query = $this->db->get('content_pages');
$rows = $query->result();
return $rows;
}
The query works in mysql but there is no change to my website?
Any clues on why?