$d2[0] ) return 1; elseif($d1[0] < $d2[0]) return -1; elseif($d1[1] > $d2[1]) return 1; elseif($d1[1] < $d2[1]) return -1; elseif($d1[2] > $d2[2]) return 1; else return -1; } /* * get the current series based on today's date * The current series is defined as being the date * that is closest to the current date without being declared in the future * * return "series id" * */ function getCurrentSeries() { global $START_HOUR; $date = date("Y-m-d"); if(date("H") < $START_HOUR ) { $date = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d")-1, date("Y"))); } $query = "SELECT * FROM lake_sunday ORDER BY date DESC"; $result = mysql_query($query); $series = ""; while($row = mysql_fetch_assoc($result)) { if(compareDate($date, $row["date"])) { $series = $row["name"]; break; } } return $series; } /* * Prints out the series Also calles the getNotesForSeries function * * @param "series id" * */ function getSeries($series) { $query = "SELECT * FROM lake_sunday WHERE `name` = '$series'"; $row = mysql_fetch_assoc(mysql_query($query)); ?>

Download the Notes