Forums

I've re-read the FAQ's on where statements. I've tried multiple ways to get data to show properly.

Using the below - the where properly captures the "published" and "auction" fields. but the fields with NOT LIKE still are displayed. Is there a different way I need to put this in CC5?

<?php
return array ( 'p.product_published ' => '1', 
'p.product_auction' => '0', 
'p.product_code NOT LIKE' => '%Watch%',
'p.product_code NOT LIKE' => '%PTA_Membership%', 
'p.product_code NOT LIKE' => '%Marquee%', 
'p.product_code NOT LIKE' => '%Donation%' ) ;
?>

Can't seem to do an "OR", so tried to create a string with "NOT LIKE" OR, and this doesn't work either.

<?php
$nonapparel = array ('Watch', 'Membership', 'Marquee', 'Bundle', 'Donation');

return array ( 'p.product_published ' => '1', 
'p.product_auction' => '0', 
'p.product_code NOT LIKE' => '%'.$nonapparel.'%'  ) ;

?>

That did the trick. Thanks Bob.