Like this:
<?
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );
header("Cache-Control: no-cache, must-revalidate" );
header("Pragma: no-cache" );
header("Content-Type: text/xml; charset=ISO-8859-1");
//////////////////////////////////////
// set these variables for your MySQL
$dbhost =
$dbuser =
$dbpass =
//////////////////////////////////////
$db = @mysql_connect($dbhost, $dbuser, $dbpass) or die ("<?xml version=\"1.0\" ?><response><content><![CDATA[<span class='error'>Database connection failed.</span>]]></content></response>");
mysql_select_db('clubcph_db');
$xml = '<?xml version="1.0" ?><response><content><![CDATA[';
if($_GET['event'] != '') {
$fields = explode("-",$_GET['event']);
$result = mysql_query("SELECT *,DATE_FORMAT(`date`,'%b %e, %Y at %l:%i%p') as thedate,DATE_FORMAT(`date`,'%c') as themonth,DATE_FORMAT(`date`,'%Y') as theyear FROM `events` WHERE YEAR(`date`) = ".$fields[0]." AND MONTH(`date`) = ".$fields[1]." AND DAYOFMONTH(`date`) = ".$fields[2]." ORDER BY `num` ASC");
$i = 0;
while($row = mysql_fetch_array($result)) {
$xml .= "<div id='event'";
if($i < (mysql_num_rows($result)-1)) $xml .= " style='border-bottom:none'";
$xml .= "><div class='heading'><div class='title'>".$row['heading']."</div><div class='posted'>".$row['thedate']."</div>";
if($i == 0) $xml .= "<div class='back'><a href='javascript:navigate(".$row['themonth'].",".$row['theyear'].",\"\")'>Return to calendar</a></div>";
$xml .= "</div><div class='line'>".$row['body']."</div><br /></div><br />";
$i++;
}
} else {
$month = $_GET['month'];
$year = $_GET['year'];
if($month == '' && $year == '') {
$time = time();
$month = date('n',$time);
$year = date('Y',$time);
}
$date = getdate(mktime(0,0,0,$month,1,$year));
$today = getdate();
$hours = $today['hours'];
$mins = $today['minutes'];
$secs = $today['seconds'];
if(strlen($hours)<2) $hours="0".$hours;
if(strlen($mins)<2) $mins="0".$mins;
if(strlen($secs)<2) $secs="0".$secs;
$days=date("t",mktime(0,0,0,$month,1,$year));
$start = $date['wday'];
$name = $date['month'];
$year2 = $date['year'];
$offset = $days + $start - 1;
if($month==12) {
$next=1;
$nexty=$year + 1;
} else {
$next=$month + 1;
$nexty=$year;
}
if($month==1) {
$prev=12;
$prevy=$year - 1;
} else {
$prev=$month - 1;
$prevy=$year;
}
if($offset <= 28) $weeks=28;
elseif($offset > 35) $weeks = 42;
else $weeks = 35;
$prevmonth = date( 'F', mktime(0, 0, 0, $prev) );
$nextmonth = date( 'F', mktime(0, 0, 0, $next) );
$xml .= "<table class='cal' cellpadding='0' cellspacing='1'>
<tr>
<td colspan='7' class='calhead'>
<table>
<tr>
<td id='calendarhead'>Clubbinghagen.dk </td>
<td class='datepicker' align='center'>
<a class='monthNav' href='javascript:navigate($prev,$prevy,\"\")' style='border:none' >$prevmonth $prevy </a>
<a class='monthNav' href='javascript:navigate(\"\",\"\",\"\")' style='border:none'><img src='images/calCenter.gif' alt='current' /></a>
<a class='monthNav' href='javascript:navigate($next,$nexty,\"\")' style='border:none'>$nextmonth $nexty</a>
<a class='monthNav' href='javascript:void(0)' onClick='showJump(this)' style='border:none'><img src='images/calDown.gif' alt='jump' /></a>
</td>
<td align='right'>
$name $year2
</td>
</tr>
</table>
</td>
</tr>
<tr class='dayhead'>
<td>Mandag</td>
<td>Tirsdag</td>
<td>Onsdag</td>
<td>Torsdag</td>
<td>Fredag</td>
<td>Lørdag</td>
<td>Søndag</td>
</tr>";
$col=1;
$cur=1;
$next=0;
for($i=1;$i<=$weeks;$i++) {
if($next==3) $next=0;
if($col==1) $xml.="\n<tr class='dayrow'>";
$xml.="\t<td ";
if(($cur==$today[mday]) && ($name==$today[month]) && ($year2==$today[year])) $xml.=" style='background-color:#F4F4F4;'";
$xml.="valign='top' onMouseOver=\"this.className='dayover'\" onMouseOut=\"this.className='dayout'\">";
if($i <= ($days+($start-1)) && $i >= $start) {
$xml.="<div class='day123'><div class='day'><b";
if(($cur==$today[mday]) && ($name==$today[month]) && ($year2==$today[year])) $xml.=" style='color:#ff00cc;'";
$xml.=">$cur</b></div></div>";
$result = mysql_query("SELECT DATE_FORMAT(`date`,'%Y-%m-%e') FROM `events` WHERE MONTHNAME(`date`)='$name' AND DAYOFMONTH(`date`)=$cur AND YEAR(`date`)=$year2");
//Get event name
$equery = "SELECT `heading` FROM `events` WHERE MONTHNAME(`date`)='$name' AND DAYOFMONTH(`date`)=$cur AND YEAR(`date`)=$year2";
$eresult = mysql_query($equery);
if(mysql_num_rows($result) > 0) {
$row = mysql_fetch_row($result);
while($erow = mysql_fetch_array($eresult)){
$xml.="<div class='calevent'>
<a href='' class='someClass' title='<img src=1.jpg>'>Curabitur dolor eros</a>
<a href='javascript:navigate(\"\",\"\",\"".$row[0]."\")'>";
$xml.=$erow[0];
$xml.="</a></div>";
}
}
$xml.="\n\t</td>\n";
$cur++;
$col++;
} else {
$xml.=" \n\t</td>\n";
$col++;
}
if($col==8) {
$xml.="\n</tr>\n";
$col=1;
}
}
$xml.="</table> ";
}
$xml .= "]]></content></response>";
echo $xml;
?>