aboutsummaryrefslogtreecommitdiffstats
path: root/include/functions_category.inc.php
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--include/functions_category.inc.php40
1 files changed, 36 insertions, 4 deletions
diff --git a/include/functions_category.inc.php b/include/functions_category.inc.php
index d4fb55aad..5cb0e727f 100644
--- a/include/functions_category.inc.php
+++ b/include/functions_category.inc.php
@@ -571,10 +571,42 @@ function initialize_category( $calling_page = 'category' )
if (isset($search['fields']['cat']))
{
- $local_clause = 'category_id IN (';
- $local_clause.= implode(',',$search['fields']['cat']['words']);
- $local_clause.= ')';
- array_push($clauses, $local_clause);
+ if ($search['fields']['cat']['mode'] == 'sub_inc')
+ {
+ // searching all the categories id of sub-categories
+ $search_cat_clauses = array();
+ foreach ($search['fields']['cat']['words'] as $cat_id)
+ {
+ $local_clause = 'uppercats REGEXP \'(^|,)'.$cat_id.'(,|$)\'';
+ array_push($search_cat_clauses, $local_clause);
+ }
+ array_walk($search_cat_clauses,
+ create_function('&$s', '$s = "(".$s.")";'));
+
+ $query = '
+SELECT DISTINCT(id) AS id
+ FROM '.CATEGORIES_TABLE.'
+ WHERE '.implode(' OR ', $search_cat_clauses).'
+;';
+ echo '<pre>'.$query.'</pre>';
+ $result = mysql_query($query);
+ $cat_ids = array();
+ while ($row = mysql_fetch_array($result))
+ {
+ array_push($cat_ids, $row['id']);
+ }
+ $local_clause = 'category_id IN (';
+ $local_clause.= implode(',',$cat_ids);
+ $local_clause.= ')';
+ array_push($clauses, $local_clause);
+ }
+ else
+ {
+ $local_clause = 'category_id IN (';
+ $local_clause.= implode(',',$search['fields']['cat']['words']);
+ $local_clause.= ')';
+ array_push($clauses, $local_clause);
+ }
}
// adds brackets around where clauses