syntax for using AND in where clause

molcomp

New Member
Hello,

I have the following where clause but it seems not to be working.

->where('projects.project_name = ' . $myDb->quote('{overlapping___project_1}') AND 'activities.activity_name = ' . $myDb->quote('{overlapping___activity}'));

Does anyone knows the proper syntact for using AND in where clause?
I have a list with one dropdown element, one condional dropdown element and in the third element calc I am trying to display data based on selecitons in the first two fields.

If I remove the AND in the where clause third element works with only one selected option.

Thanks everyone.
Alex
 
I guess you have to ask before you figure it out by yourself :).
Solution was just use double where clause
->where('projects.project_name = ' . $myDb->quote('{overlapping___project_1}') )
->where('activities.activity_name = ' . $myDb->quote('{overlapping___activity}'));
 
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top