midnites Posted March 18, 2014 Share Posted March 18, 2014 Ok, I'm trying to adapt a bit of code. Right now it limits what it returns to 1 category, category "2", I need it to return items from categories 2,3,4,5,6,7. I know this is pretty basic, but I can't get it to work. The $includeCat part. Thanks! $currentItem = K2Table::getInstance('K2Item', 'Table'); $currentItem->load($itemID); $itemCat = $currentItem->get('catid'); $includeCat = 2; if($includeCat) $query .= " AND c.id = {$includeCat} "; $query .= " AND c.trash = 0 AND (i.id) IN ({$sql}) ORDER BY i.created DESC"; Quote Link to comment Share on other sites More sharing options...
Ch0cu3r Posted March 18, 2014 Share Posted March 18, 2014 (edited) try $includeCat = '2,3,4,5,6,7'; if($includeCat) $query .= " AND c.id = IN($includeCat) "; Edited March 18, 2014 by Ch0cu3r Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.