Archief - PHP: Probleem met output van agenda

<h1>Agenda <?php echo date("Y") ; ?></h1>

<table width="100%"  border="1" cellspacing="0" cellpadding="0">

<?php
include('dbconnect.php');
$currentmonth = date("m");
$currentyear = date("Y");

$sql = mysql_query("select * from agenda order by monthfield, date desc") or die(mysql_error());

$prevCat='';
while($row = mysql_fetch_array($sql))
{
	$event = $row["eventfield"];
	$id = $row["idfield"];
	$url = $row["urlfield"];
	$date = $row["date"];
	$month = $row["monthfield"];
	
	$val = strtotime($month);
	$month2 = date("F", $val);
	$datecorrection = strtotime($date);
	$year = date("Y", $datecorrection);
	$day = date("l", $datecorrection);
	$numberday = date("dS", $datecorrection);
	
	
	if($currentyear == $year) {

	// is the month different ?
	// if so, print it
		if ($month2 != $prevCat)  {
		echo "<tr><td><h1>$month2</h1></td></tr>";
		}
 		echo  "<tr><td><b><a href='$url'>$event</a></b></td>";
		echo  "<td>$day the $numberday<td></tr>";
	}
$prevCat = $month2;
}
?>
</table>

-- 
-- Table structure for table `agenda`
-- 

CREATE TABLE `agenda` (
  `id` int(11) NOT NULL auto_increment,
  `date` date NOT NULL,
  `event` text NOT NULL,
  `url` varchar(200) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `agenda`
-- 

INSERT INTO `agenda` (`id`, `date`, `event`, `url`) VALUES (1, '2006-07-27', 'Test event 1', 'http://www.test.be'),
(2, '2006-08-31', 'Laatste werkdag', 'http://www.feest.be');

$curmonth = date("m");
$curyear = date("Y");
$prevCat = '';

$res = mysql_query("SELECT date, event, url FROM agenda ORDER BY date DESC");

while ($row = mysql_fetch_row($res))
{
    $date   = $row[0];
    $event  = $row[1];
    $url    = $row[2];

    $_year  = date("Y", strtotime($date));
    $_month = date("m", strtotime($date));
    $_day   = date("d", strtotime($date));
    
    if ($curyear == $_year)
    {
        if ($_month != $prevCat)
        {
            echo '<tr><td><h1>'.date("F", strtotime($date)).'</h1></td></tr>';
        }
        echo '<tr><td><b><a href="'.$url.'">'.$event.'</a></b></td>'
            .'<td>'.$_day.' the '.date("dS", strtotime($date)).'</td></tr>';
    }
    $prevCat = $_month;
}