Excluding Specific Categories

Hi, osga.

If the category list options are set up within the News section editor, I use something like the following...

list($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'where'    => ' category NOT LIKE "%YourCategoryName%" ',
));

Replace YourCategoryName with the name of your desired category.

~ Deborah

thank you for the response... how would we implement this on the page...?

page included...

Osga, I believe the only change you'll need to make is to add the 'where' clause as shown here:

  // load records
  list($articlesRecords, $articlesMetaData) = getRecords(array(
    'tableName'   => 'articles',
    'where'       => ' category NOT LIKE "%YourCategoryName%" ',
    'limit'       => '9',
    'loadUploads' => '0',
    'orderBy'     =>  'date DESC',
  ));


You'll need to edit YourCategoryName to match the actual category to be excluded.

~ Deborah

generates this error

"MySQL Error: Unknown column 'category' in 'where clause'"

(new page for code attached....)

Hi Deborah... we finally got this work with a little playing around, Note the "CategoryNum" as opposed to the suggested "category" in the statement (make a mental note of that)...

now the question is: Do you know the syntax for excluding more than 1 category?

  'where'       => ' categoryNum NOT LIKE "9" ',

thanks for all ur help so far!

Osga, try this:

 'where' => ' categoryNum NOT LIKE "9" AND categoryNum NOT LIKE "5"',

~ Deborah

that worked like a charm Deborah, Thank You!