so far that is all i have managed. basically the script will be a link archive. only one month is visible on the page and each day of that month, previous months are then archived.
<?php
$con = mysql_connect("*****","*****","*****");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("*****", $con);
$result = mysql_query("SELECT * FROM info ORDER BY id DESC");