[Php-calendar-discussion] Multiple search bug
Brought to you by:
sproctor
From: William B. S. <ws...@fi...> - 2004-12-30 18:49:34
|
I found what appears to be a bug in the search.php. When attempting to search with multiple terms it fails. Starting at line 38 in search.php I replaced this: foreach($keywords as $keyword) { $where .= "subject LIKE '%$keyword%' " ."OR description LIKE '%$keyword%'\n"; } with this: foreach($keywords as $keyword) { $where .= "(subject LIKE '%$keyword%' " ."OR description LIKE '%$keyword%') AND "; } $where = rtrim($where,"AND "); Just trying to help. Thanks, Barrett -- Fiver Computing Corporation http://www.fivercomputing.com (781)405-4686 |