Location: PHPKode > scripts > PHP calendar with AJAX driven agenda > MyWeb20Agenda/MyWeb20Agenda/includes/agenda_show.php
<?php 
	$dblogin = 'calendar_conn.php';	
	$m = $_REQUEST['m'];
	$y = $_REQUEST['y'];
	$day = $_REQUEST['day'];		
	$thismonth = date("F",mktime(0,0,0,$m,$day,$y));
	$days = date("t",mktime(0,0,0,$m,$day,$y));
echo ("
<table width=\"450\" border=\"0\" cellspacing=\"2\" cellpadding=\"0\">
			<tr>
				<td colspan=\"5\" class=\"tabtitle\" nowrap><span class=\"title\">My Agenda - $thismonth Entries</td>
				<td align=\"right\" class=\"showbutton\"><a href=\"#\" onClick=\"closeAgenda();\">x</a></td>
			</tr>
			<tr>
				<td class=\"tabdays\">Date/Time</td>
				<td class=\"tabdays\">Task</td>
				<td class=\"tabdays\">Location</td>
				<td class=\"tabdays\">Importance</td>
				<td class=\"tabdays\">Status</td>
				<td class=\"tabdays\">Id</td>
			</tr>");
?>
<?php

	$fields = " * ";
	$tabname = "agenda";
	$selectid = $y;
	$selectid1 = $m;
	$selectid2 = $day;

	$selective = 	"YEAR(dates) = '$selectid' 
				AND MONTH(dates) = '$selectid1' 
				AND DAY(dates) = '$selectid2'";
	$standard = 'simple';
	$selectorder = "starttime";
	$noquery = 'Error table query';
	$badnews = 'Error reading data';
	
	require_once 	'../class/agenda.data.class.php';
	$selectagenda = new SelectData($dblogin,$fields,$tabname,$data,$selective,$standard,
								$selectid,$selectorder,$goodnews,$badnews,$noquery,
								$message,$deleteid,$insertid,$tbvalues,$days,$updateid,
								$updfieldid,$m,$y);
	echo $selectagenda->showTable();
	
?>
<?php echo "</table>"; ?>
Return current item: PHP calendar with AJAX driven agenda