<?php
 $dbng=mysql_connect("localhost","dbuser","mtfai2479");
 mysql_select_db("hockey",$dbng);
 
 $sql=mysql_query("select game.time, game.date, school.school from game LEFT JOIN school on school.id=game.opponent where date >= curdate() order by date limit 2");

if (mysql_num_rows($sql) < "1") {

} else {

 while ($res=mysql_fetch_array($sql)) {
    if (!$i) {
        $time=explode(":", $res["time"]);
        $date=explode("-", $res["date"]);
        $school=$res["school"];
        $i=1;
    } else {
        $date2=explode("-", $res["date"]);
        $nextschool=$res["school"];
    }        
 }
 
echo "var mycountdown = new Countdown();
with (mycountdown) {
  tagID = \"countdown\";
  setEventDate(".$date[0].", ".floor($date[1]).", ".floor($date[2]).", ".(floor($time[0])-6).", ".floor($time[1]).", 0);
  event = \"$school\";
  onevent = \"The $school game is on!\";
  afterevent = \"Next up: $nextschool on ".floor($date2[1])."/".floor($date2[2])."/".$date2[0]."\";
}
addCountdown(mycountdown);";
}
?>