[eluser]jbads[/eluser]
The problem I have with the following query is that it is still returning results from all the regions, not just the region speicfied in $region. I can't for the life me figure out how to return results only where the user_region column has data that matches $region.
Could anybody offer any advice on this?
Code:
function _search_process($users, $members, $region, $keyword){
//Get data for all users based on search item and region
if($region !== 'All')
{
$i = $this->db->select($members.'.user_id,'.$members.'.user_avatar,'.$members.'.user_display_name,'.$members.'.user_location,'.$members.'.user_region,'.$members.'.user_skills,'.$users.'.username,'.$users.'.banned_id')
->from($members)
->join($users, $users.'.user_id = '.$members.'.user_id', 'left')
->like('user_firstname', $keyword)
->or_like('user_lastname', $keyword)
->or_like('user_display_name', $keyword)
->or_like('user_location', $keyword)
->or_like('user_skills', $keyword)
->or_like('user_interests', $keyword)
->or_like('user_work', $keyword)
->or_like('user_about', $keyword)
->where('user_region', $region)
->having(array($users.'.banned_id =' => '0'))
->get();
return $var = ($i->num_rows > 0) ? $i->result_array() : false;
}
Regards, Jake