Open Script Solution

//List premade answers.
$select='SELECT premade.*,dept_name ';
$from='FROM '.KB_PREMADE_TABLE.' premade LEFT JOIN '.DEPT_TABLE.' USING(dept_id) ';
 
//make sure the search query is 3 chars min...defaults to no query with warning message
if($_REQUEST['a']=='search') {
    if(!$_REQUEST['query'] || strlen($_REQUEST['query'])<3) {
        $errors['err']='Search term must be more than 3 chars';
    }else{
        //fulltext search.
        $search=true;
        $qstr.='&a='.urlencode($_REQUEST['a']);
        $qstr.='&query='.urlencode($_REQUEST['query']);
        $where=' WHERE MATCH(title,answer) AGAINST ('.db_input($_REQUEST['query']).')';
        if($_REQUEST['dept'])
            $where.=' AND dept_id='.db_input($_REQUEST['dept']);
    }
}
 
//I admit this crap sucks...but who cares??

//List premade answers.
$select='SELECT DISTINCT(d.dept_name), premade.* ';
$from='FROM '.KB_PREMADE_TABLE.' premade, '.DEPT_TABLE.' d ';
 
//make sure the search query is 3 chars min...defaults to no query with warning message
if($_REQUEST['a']=='search') {
    if(!$_REQUEST['query'] || strlen($_REQUEST['query'])<3) {
        $errors['err']=I_S_PREM_SEARCH_TERM;
    }else{
        //fulltext search.
        $search=true;
        $qstr.='&a='.urlencode($_REQUEST['a']);
        $qstr.='&query='.urlencode($_REQUEST['query']);
        $searchfor = $_REQUEST['query'];
        $where=" WHERE (premade.title LIKE '%$searchfor%' 
                 OR premade.answer LIKE '%$searchfor%') 
                 AND (d.dept_id = premade.dept_id OR premade.dept_id = 0) "; 
	if($_REQUEST['dept'])
            $where.=' AND d.dept_id='.db_input($_REQUEST['dept']);
    }
}
if (!isset($where)) $where = 'WHERE d.dept_id = premade.dept_id 
                              OR premade.dept_id = 0'; 
//I admit this crap sucks...but who cares??