P
|
pamgeo 2/15/2017 |
hey , change this $query->addWhere("dept like '". %$login[1]% ."'"); to the following Hi, In phpRunner, I am trying to show only records that belong to the user based on the dept column when the user login. I have user_login table with following columns: eg. staff_id = A1 dept = deptA,deptB,deptC I have record table with the following columns: eg. record_id = 100 dept = deptA,deptB In "After Successful login", i have the following code which capture user's dept.
|
A
|
azmi 2/16/2017 |
hey , change this $query->addWhere("dept like '". %$login[1]% ."'"); to the following $query->addWhere("dept like '%". $login[1] ."%'"); and retry. |