MySQL: Abfrag im Zeitraum X

[hansi]

Hi,

Ich bekomme nur: Check your Syntax.

<?php
 include('mysql.php');
 $result = mysql_query("SELECT * FROM CMS_News BETWEEN '2007.04.01' AND '2007.04.03'", $DatabasePointer);

while($row = mysql_fetch_array($result)) {
      $date = $row['date'];
      $title = $row['title'];
      $details = $row['details'];
}
?>

was ist falsch?

gruß
hansi