Changeset 19 for trunk/include/functions_category.inc.php

Timestamp:

May 27, 2003, 10:56:13 PM (21 years ago)

Author:

z0rglub

Message:

* empty log message *

File:

• trunk/include/functions_category.inc.php (modified) (2 diffs)

trunk/include/functions_category.inc.php

@@ -406 +406 @@
         $sql_search = array();
         foreach ( $words as $i => $word ) {
+          // if the user searchs any of the words, the where statement must
+          // be :
+          // field1 LIKE '%$word1%' OR field2 LIKE '%$word1%' ...
+          // OR field1 LIKE '%$word2%' OR field2 LIKE '%$word2%' ...
           if ( $_GET['mode'] == 'OR' )
           {
@@ -414 +418 @@
             }
           }
+          // if the user searchs all the words :
+          // ( field1 LIKE '%$word1%' OR field2 LIKE '%$word1%' )
+          // AND ( field1 LIKE '%$word2%' OR field2 LIKE '%$word2%' )
           else if ( $_GET['mode'] == 'AND' )
           {