
<?php
function getWhereString($sKeywords, $sAndor, $aFields){
		$sKeywords = ereg_replace(" +", " ", trim($sKeywords));
        $aKeywords = split('[ +]', $sKeywords);
        $sWhere = '';
        for($i=0;$i<count($aKeywords);$i++){
            $sWhere .= (($i==0)?' ':' '.$sAndor.' ').(($sAndor=='AND')?'( ':'');
            for ($iK = 0; $iK<count($aFields); $iK++){
                $sWhere .= (($iK==0)?' ':' OR ').$aFields[$iK]." LIKE '%".$aKeywords[$i]."%' ";    
            }
            $sWhere .= (($sAndor == 'AND')?' ) ':' ');
        }
        return $sWhere;
} 
?>