Welcome Guest, Not a member yet? Register   Sign In
Database Error!!
#11

[eluser]Shaileen[/eluser]
ok...i got that point.. but how do i write this line in CI..

it is originally in perl..thats where im geting confused..

WHERE lower($searchField) LIKE lower('%$searchText%') $groupSearch AND


is it something like this??

$this->db->where("$searchField like", "%$searchText%");
$this->db->where($searchGroup, $groupSearch);

or a different solution!!??
#12

[eluser]danmontgomery[/eluser]
Those three variables could hold any of a thousand different values, you're going to have to be more specific.

read the userguide, specifically the section on $this->db->like().
#13

[eluser]Shaileen[/eluser]
ok..i got it..


this soloved my problem!!!

if($groupSearch != '' )
{
$this->db->where($groupSearch );
}

thanks for your help..




Theme © iAndrew 2016 - Forum software by © MyBB