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

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

?>

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

  list($afishRecords, $afishMetaData) = getRecords(array(
    'tableName'   => 'afish',
    'where' => 'date <= ((NOW() + INTERVAL 7 DAY) AND date >= NOW()',
  ));

?>

with foreach:

<?php foreach ($afishRecords as $record): ?><section>
            <header>
                <h1 style="width:90%;"><span style="font-size:12px;"><?php echo date("d.m.Y", strtotime($record['date'])) ?></span><br /><?php echo $record['title'] ?></h1>
            </header>
            <div class="content" style="width:100%;">
            <?php echo $record['content'] ?>
            </div>
        </section><?php endforeach ?>

and 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"

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

one quick question - Is there a way to make form for change page number with input field value? I mean after search :)

Example: my url - list.php?offer=sell&price_min=&price_max=&submit=Submit&page=3 . I want to have form with input field where i can put some value like "9" and my url change to this - list.php?offer=sell&price_min=&price_max=&submit=Submit&page=9 .

Want to save my search criteria and change only page number.

Thanks