List upcoming events only

Can you copy and paste the full page of actual code from your text editor into a reply forum post so we can have the actual code to work with?

This will also make it easier to reply with the correct code.

Thanks!

Sorry, please refer to this line - slight mistake on my part:

<?php
  require_once "........./lib/viewer_functions.php";

  list($afishRecords, $afishMetaData) = getRecords(array(
    'tableName'   => 'afish',
    'where' => 'date <= "'.date('Y-m-d H:i:s', time()+(60*60*24*7)).'" AND date >= "'.date('Y-m-d H:i:s', time()).'"',
  ));

?>