Grouping Search Clauses with PHP

[dph]

Hi there,

I'm trying to create a web page that searches multiple fields and returns a list of employees matching the search. Our database contains an archive of employees identified as terminated by a numeric field "Terminated". Basically I'm trying to see how one would go about achieving this SQL statement:

SELECT * FROM employees WHERE (firstname LIKE '%searchValue%' OR lastname LIKE '%searchvalue%' OR program LIKE '%searchvalue%' OR department LIKE '%searchvalue%') AND Terminated = 0

As there doesn't seem to be a way to add the necessary parentheses using FX for PHP, I tried adding the parameters in two ways as follows:

Try 1:

$EmpDB->AddDBParam('First Name',$theSearch,'cn');

$EmpDB->AddDBParam('-lop','or');

$EmpDB->AddDBParam('Last Name',$theSearch,'cn');

$EmpDB->AddDBParam('-lop','or');

$EmpDB->AddDBParam('Department',$theSearch,'cn');

$EmpDB->AddDBParam('-lop','or');

$EmpDB->AddDBParam('Program',$theSearch,'cn');

$EmpDB->AddDBParam('Terminated','0','eq');

Try 2:

$EmpDB->AddDBParam('First Name',$theSearch,'cn');

$EmpDB->AddDBParam('Terminated','0','eq');

$EmpDB->AddDBParam('-lop','or');

$EmpDB->AddDBParam('Last Name',$theSearch,'cn');

$EmpDB->AddDBParam('Terminated','0','eq');

$EmpDB->AddDBParam('-lop','or');

$EmpDB->AddDBParam('Department',$theSearch,'cn');

$EmpDB->AddDBParam('Terminated','0','eq');

$EmpDB->AddDBParam('-lop','or');

$EmpDB->AddDBParam('Program',$theSearch,'cn');

$EmpDB->AddDBParam('Terminated','0','eq');

Neither one of which worked because there is no way to force the logic that is required here. At this point I feel like I'm up a creek and missing my paddle. Anyone ever run into this?