includes/search.php
changeset 757 7ba7b85e1195
parent 756 e8cf18383425
child 758 6b79a49f85f0
equal deleted inserted replaced
756:e8cf18383425 757:7ba7b85e1195
   952   {
   952   {
   953     $where = array('any' => array(), 'req' => array(), 'not' => array());
   953     $where = array('any' => array(), 'req' => array(), 'not' => array());
   954     $where_any =& $where['any'];
   954     $where_any =& $where['any'];
   955     $where_req =& $where['req'];
   955     $where_req =& $where['req'];
   956     $where_not =& $where['not'];
   956     $where_not =& $where['not'];
   957     $title_col = ( $case_sensitive ) ? $options['titlecolumn'] : 'lcase(' . $options['titlecolumn'] . ')';
   957     $title_col = ( $case_sensitive ) ? $options['titlecolumn'] : ENANO_SQLFUNC_LOWERCASE . '(' . $options['titlecolumn'] . ')';
   958     if ( isset($options['datacolumn']) )
   958     if ( isset($options['datacolumn']) )
   959       $desc_col = ( $case_sensitive ) ? $options['datacolumn'] : 'lcase(' . $options['datacolumn'] . ')';
   959       $desc_col = ( $case_sensitive ) ? $options['datacolumn'] : ENANO_SQLFUNC_LOWERCASE . '(' . $options['datacolumn'] . ')';
   960     else
   960     else
   961       $desc_col = "''";
   961       $desc_col = "''";
   962     foreach ( $terms['any'] as $term )
   962     foreach ( $terms['any'] as $term )
   963     {
   963     {
   964       $term = escape_string_like($term);
   964       $term = escape_string_like($term);