= " . $startTimestamp . " AND UNIX_TIMESTAMP(dateField) <= " . $endTimestamp . " AND internal_display_only=0 "; $sql .= "ORDER BY UNIX_TIMESTAMP(dateField) ASC"; // Open Database Connection $dbLink = mysql_connect($dbHost, $dbUser, $dbPass); if (!$dbLink){ die ("Database: Couldn`t connect to mySQL Server"); } mysql_select_db($dbName, $dbLink) or die ("Database: Couldn`t open Database"); // Read in Records from Database $dbResult = mysql_query($sql, $dbLink) or die ("MySQL Error: " . mysql_error() ); $numRecords = mysql_num_rows($dbResult); for($i=0;$i < $numRecords;$i++){ $temp = mysql_fetch_assoc($dbResult); if (!get_magic_quotes_gpc()) { $temp['title'] = stripslashes($temp['title']); $temp['body'] = stripslashes($temp['body']); } $records[] = $temp; } // Close Database Connection mysql_close($dbLink); ?> John Milledge Academy
Why JMA? About Us News Photos/Videos Trojan Armor
  Academics Athletics Development Alumni
Employment Opportunities
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

JMA Headlines

Archives

 


= " . $firstDayTimestamp . " AND UNIX_TIMESTAMP(dateField) <= " . $lastDayTimestamp . " AND internal_display_only=0 "; $sql .= "ORDER BY timestampField ASC"; // Read in Data $dbResult = mysql_query($sql, $dbLink) or die ("MySQL Error: " . mysql_error() ); $numRecords = mysql_num_rows($dbResult); $eventsArray[] = ""; for($i=0;$i<$numRecords;$i++){ $row = mysql_fetch_assoc($dbResult); $day = date("j",$row['timestampField']); // Check Date isn`t already in $eventsArray if(!in_array($day,$eventsArray)){ $eventsArray[] = $day; } } // Close Database Connection mysql_close($dbLink); // Return eventsArray to code that called function return $eventsArray; } ?> \n"; echo "

<" . date("F Y", mktime(0, 0, 0, $month, 1, $year)) . ">
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; # Calculate number of rows $today = date("d"); $totalCells = $firstDay + $daysInMonth; if($totalCells < 36){ $rowNumber = 5; } else { $rowNumber = 6; } $dayNumber = 1; # Create Rows for($currentRow=1; $currentRow <= $rowNumber; $currentRow++){ if($currentRow == 1){ # Create First Row echo "\n"; for($currentCell = 0; $currentCell<7; $currentCell++){ if($currentCell == $firstDay){ # First Day of the Month $day = $dayNumber . "/" . $month . "/" . $year; $link = "" . $dayNumber . ""; if($dayNumber % 2 == 0){ if(in_array($dayNumber,$eventsArray)){ echo "\n"; } else { echo "\n"; } } else { if(in_array($dayNumber,$eventsArray)){ echo "\n"; } else { echo "\n"; } } $dayNumber++; } else { if($dayNumber > 1){ $day = $dayNumber . "/" . $month . "/" . $year; $link = "" . $dayNumber . ""; # First Day Passed so output Date if($dayNumber % 2 == 0){ if(in_array($dayNumber,$eventsArray)){ echo "\n"; } else { echo "\n"; } } else { if(in_array($dayNumber,$eventsArray)){ echo "\n"; } else { echo "\n"; } } $dayNumber++; } else { # First Day Not Reached so display blank cell echo "\n"; } } } echo "\n"; } else { # Create Remaining Rows echo "\n"; for($currentCell = 0; $currentCell < 7; $currentCell++){ $day = $dayNumber . "/" . $month . "/" . $year; $link = "" . $dayNumber . ""; if($dayNumber > $daysInMonth){ # Days in month exceeded so display blank cell echo "\n"; } else { if($dayNumber % 2 == 0){ if(in_array($dayNumber,$eventsArray)){ echo "\n"; } else { echo "\n"; } } else { if(in_array($dayNumber,$eventsArray)){ echo "\n"; } else { echo "\n"; } } $dayNumber++; } } echo "\n"; } } echo "
SunMonTueWedThuFriSat
" . $link . "" . $dayNumber . "" . $link . "" . $dayNumber . "" . $link . "" . $dayNumber . "" . $link . "" . $dayNumber . " 
 " . $link . "" . $dayNumber . "" . $link . "" . $dayNumber . "
\n"; echo "
\n"; ?>

0) { // Show if recordset empty ?>

Pledge Card

Summer Office Hours
8:30 - Noon

Supply List

 

 

NOTICE OF NON-DISCRIMINATION POLICY AS TO STUDENTS:

John Milledge Academy admits students of any race, color, or nationality to all the rights, privileges, programs, and activities generally accorded or made available to students at the school. It does not discriminate on the basis of race, color, nationality, or ethnic origin in administration of its educational policies, scholarship and loan programs, athletics, and other school administered programs.

Site hosted by Central GA online