Display A Message If “Where” Criteria Not Met

Hi all,

(Sorry I posted this in the wrong forum)

I’ve set up a page to list events in 3 separate groups on the page using separate "list records" calls and "where" statements.

1) Ones that have a sponsored field checked
2) Ones that have starting dates or receptions that occur during the upcoming 7 days.
3) Other upcoming events

The sorting works, however I’m trying to display a specific messages depending on whether there are events that are meet the 7 day 'where" criteria and I can’t get that to work.

Here’s the code I’m using. At the beginning of the group:

<?php
list($e_blast_events_noticeRecords, $e_blast_events_noticeMetaData) = getRecords(array(
'tableName' => 'e_blast_events_notice',
'where' => '(NOW() + INTERVAL 7 DAY) >= event_reception_date AND event_reception_date >= TIMESTAMP(CURDATE(), "00:00:00") OR (NOW() + INTERVAL 7 DAY) >= event_start_date AND event_start_date >= TIMESTAMP(CURDATE(), "00:00:00")',
'orderBy'=> 'neverRemove ASC, event_start_date ASC',
));

?>

And to display the messages:
<?php if($e_blast_events_noticeRecords) echo "These events are opening or have a reception during the next 7 days."; ?>

<?php if(!$e_blast_events_noticeRecords) echo "Sorry, none of our events listings are opening or have a reception during the next 7 days.<br />But there are many events listed below to choose from.";
?>

My guess is that the "where" criteria are being ignored and since there are records, the first message always shows.

Any ideas how to fix this?

Thanks,

Jerry Kornbluth