Login

09-07-2012, 01:27 PM

[eluser]codemonkey[/eluser]
Hello,

Here is the query in question

Code:
$this->db->where('added_by', $tech);

$this->db->or_like($infoarray);

$this->db->limit(100);

$this->db->order_by('date_created', 'DESC');

$query = $this->db->get('item_history');

return $query->result();

Why doesn't the WHERE work? I want to limit the results based on the tech logged in.

Code:
$tech = $_SESSION['username'];

$match = $this->input->post('search');  

$infoarray = array(

 'ticket_num' => $match, 

 'serial_num' => $match,

 'part_num' => $match,

 'make' => $match,

 'model' => $match,

 'user_first_name' => $match,

 'user_last_name' => $match,

 'reason' => $match,

 'date_created' => $match

);

From profiler

Code:
SELECT *

FROM (`item_history`)

WHERE `added_by` =  'tech1'

AND  `ticket_num`  LIKE '%%'

OR  `serial_num`  LIKE '%%'

OR  `part_num`  LIKE '%%'

OR  `make`  LIKE '%%'

OR  `model`  LIKE '%%'

OR  `user_first_name`  LIKE '%%'

OR  `user_last_name`  LIKE '%%'

OR  `reason`  LIKE '%%'

OR  `date_created`  LIKE '%%'

ORDER BY `date_created` DESC

LIMIT 100

Thank you