$date = '2007-05-31';
//connect to the database
mysql_connect('db.sabren.com',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

// run the query
$query = "SELECT * FROM news_db WHERE day LIKE '%$date%' ORDER
BY ID DESC";
$result=mysql_query($query);

// start with last_seen_day as an empty so that the first
// real date is different, triggering the header
$last_seen_day = "";

// now loop through the result set
while ($row = mysql_fetch_assoc($result)) {

// show the entry
echo ('

‘ . $row["title"] .
“

“);
}

mysql_close();
mysql_free_result($result);
?>