printf("<<", $year - 1, $month); ?>
|
echo $year; ?>
|
printf(">>", $year + 1, $month); ?>
|
 |
|
 |
printf("");
$prev_month_info = getdate(mktime(0, 0, 0, $month - 1, 1, $year));
printf("<< | ", $prev_month_info["year"], $prev_month_info["mon"]);
$begin_date = mktime(0, 0, 0, $month, 1, $year);
$date_info = getdate($begin_date);
printf("%s | ", $date_info["month"]);
$next_month_info = getdate(mktime(0, 0, 0, $month + 1, 1, $year));
printf(">> | ", $next_month_info["year"], $next_month_info["mon"]);
printf(" \n");
$row_count = 0;
$first_row = 1;
$query = sprintf("SELECT DATE_FORMAT(date,'%%m/%%d'), location, address1, address2, DATE_FORMAT(date, '%%h:%%i %%p'), notes FROM live_performance WHERE date >= '%s' AND date < DATE_ADD('%s', INTERVAL 1 MONTH) ORDER BY date", date("Y-m-d H:i:s", $begin_date), date("Y-m-d H:i:s", $begin_date));
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($myrow = mysql_fetch_row($result))
{
if ($first_row == 1)
{
printf("\n\n");
printf("DATE | \n");
printf("LOCATION | \n");
printf("ADDRESS | \n");
printf("TIME | \n");
printf("NOTES | \n");
printf(" \n");
$first_row = 0;
}
$row_count = $row_count + 1;
if (0 == ($row_count % 2))
{
$background = 0x9E8C4F;
}
else
{
$background = 0x8E4622;
}
if (strlen($myrow[3]) == 0)
{
$address = sprintf("%s", $myrow[2]);
}
else
{
$address = sprintf("%s %s", $myrow[2], $myrow[3]);
}
printf("\n", $background);
printf("%s | \n", $myrow[0]);
printf("%s | \n", $myrow[1]);
printf("%s | \n", $address);
printf("%s | \n", $myrow[4]);
printf("%s | \n", $myrow[5]);
printf(" \n");
}
if ($first_row == 1)
{
printf("No performances found.\n");
}
else
{
printf(" \n");
}
mysql_close($db);
?>
|