List upcoming events only

Hey degreesnorth,

You just need to add a where statement that tells your getRecords function to return records that are greater than the current date:

//Get current date 1 second before midnight 
$today = date('Y-m-d 23:59:59');


 // load records from 'upcoming_events' that have a date greater than 1 second before midnight today.
  list($upcoming_eventsRecords, $upcoming_eventsMetaData) = getRecords(array(
    'tableName'   => 'upcoming_events',
    'where'       => "`date` > '$today'", 
    'limit'       => '1',
    'loadUploads' => true,
    'allowSearch' => false,
  ));

Thanks!

Greg

Perfect, thanks so much.

Hi degreesnorth,

Sorry I didn't see this.

It's(relatively)  easy to add more complex functionality to the equation.

Lets say you wanted to show only this weeks upcoming events as a group.

You might use something like:

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

To filter those records.

There are other time related 'recipes' in the CMSB Cookbook http://www.thecmsbcookbook.com

Best,

Jerry Kornbluth

Hello,

just want to ask is it possible to show results only from next seven days based on only date field. I mean today + next seven days only with date field?

Cheers

Is there anybody here who can help me with this?

Hi there - yes, you can change the where clause to something like this:

<?php
    list($e_blast_events_noticeRecords, $e_blast_events_noticeMetaData) = getRecords(array(
    'tableName'   => 'e_blast_events_notice',
      'where' => 'date <= ((NOW() + INTERVAL 7 DAY) AND date >= NOW()',  
      ));  
      
    ?>

i got this error - "MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY dragSortOrder' at line 4"

Hello. Can you give me the 'where' statement if I need to show Listings from the current date to the last 7 days previously posted?

So I need to show the last 7 days Listings up until the current date. Thank you.