');
if ($Month - 1 < 1) {
$MonthL = 12;
$YearL = $Year - 1;
}
else $MonthL = $Month - 1;
echo('');
echo('
');
echo('');
/********** END OF LEFT ARROW **********/
echo(' ');
echo($strDate["month"] ." ". $Year);
echo(' ');
/********** RIGHT ARROW **********/
if ($Month + 1 > 12) {
$MonthR = 1;
$YearR = $Year+ 1;
}
else $MonthR = $Month + 1;
echo('');
echo('
');
echo('');
echo(''); /********** END OF RIGHT ARROW **********/ ?>
| '); // beginning blank cells } /********** SET UP CONNECTION & RECORDSET OBJECTS **********/ $where = "WHERE Month = ". $Month ." AND Year = ". $Year .""; $strSQL = "SELECT * FROM calendar ". $where; $conn = @mysql_connect("localhost", "islander", "parvenu") or die(mysql_error()); $db = @mysql_select_db("javascript", $conn) or die(mysql_error()); $rsMonth = @mysql_query($strSQL, $conn); mysql_close($conn); /********** END OF SET UP CONNECTION & RECORDSET OBJECTS **********/ for ($i = 0; $i < $daysInMonth;) { if ($column++ != 7) { if ($now["mon"] == $Month && $now["mday"] == $Day && $now["year"] == $Year){ echo(' | '. $Day++ ."");
if (mysql_num_rows($rsMonth)) {
mysql_data_seek($rsMonth, 0);
while ($row = mysql_fetch_assoc($rsMonth)) {
if ($row["Day"] == $Day - 1) {
echo(' '. $row["Subject"] .' '); } } } echo(' | ');
}
else {
echo(''. $Day++ ."");
if (mysql_num_rows($rsMonth)) {
mysql_data_seek($rsMonth, 0);
while ($row = mysql_fetch_assoc($rsMonth)) {
if ($row["Day"] == ($Day - 1)) {
echo(' '. $row["Subject"] .' '); } } } echo(' | ');
}
$i++;
}
else {
echo("\n");
echo("
| '); // ending blank cells } } /********** END OF BODY OF THE TABLE **********/ ?> |