disculpa soy nuevo como es que se logra eso, el javascript es este:
<script type="text/javascript">
function dateChanged(calendar) {
// Beware that this function is called even if the end-user only
// changed the month/year. In order to determine if a date was
// clicked you can use the dateClicked property of the calendar:
if (calendar.dateClicked) {
// OK, a date was clicked, redirect to /yyyy/mm/dd/index.php
var y = calendar.date.getFullYear();
var m = calendar.date.getMonth(); // integer, 0..11
var d = calendar.date.getDate(); // integer, 1..31
// redirect...
window.location = "/" + y + "/" + m + "/" + d + "/index.php";
}
};
Calendar.setup(
{
flat : "calendar-container", // ID of the parent element
flatCallback : dateChanged // our callback function
}
);
</script>
y en donde quiero que se muestre el resultado es este:
<?php
$db = mysql_connect('localhost', 'root', '*****');
mysql_select_db("aprender", $db);
$result = mysql_query("select * from agenda");
echo "<h3><center>Agenda del dia</center></h3>";
echo "<center><table border=1>";
echo "<tr><td><center><b>Fecha</b><td><center><b>Hora</b><td><center><b>Actividad</b><td><center><b>Ciudad</b><td><center><b>Lugar</b></tr>";
while($myrow = mysql_fetch_array($result))
{
echo "<tr><td>";
echo $myrow["fecha"];
echo "<td>";
echo $myrow["hora"]; echo "<td>";
echo $myrow["actividad"]; echo "<td>";
echo $myrow["ciudad"]; echo "<td>";
echo $myrow["lugar"]; echo "<td>";
}
echo "</table>";
?>