$date_array[0] ){ for($count2 = 0 ; $count2 < round($date_num)+1 ; $count2++ ){ $eventshow[date("j", $date_array[0])] .= '
  • '.$dataeventCalendar[$count]["name"].'
    • '; $date_array[0] += 86400; } }else{ $eventshow[date("j", $dataeventCalendar[$count]["date"])] .= '
  • '.$dataeventCalendar[$count]["name"].'
    • '; } } $sqlnewsCalendar = "SELECT * FROM `news` WHERE eventCalenderID = '15' and date BETWEEN '".$wherestart."' AND '".$whereend."' AND showCal = '1' ORDER BY `sorting` DESC"; $resultnewsCalendar = mysql_query($sqlnewsCalendar); $datanewsCalendar = array(); $newsshow = array(); for($count=0; $row=mysql_fetch_array($resultnewsCalendar); $count++) { $datanewsCalendar[$count] = $row; $date_array = split("-",$datanewsCalendar[$count]["date"]); $date_num = ($date_array[1] - $date_array[0])/3600/24; //echo $date_num; if($date_array[1] > $date_array[0] ){ for($count2 = 0 ; $count2 < round($date_num)+1 ; $count2++ ){ $newsshow[date("j", $date_array[0])] .= '
  • '.substr($datanewsCalendar[$count]["name"],0,15).' ...
    • '; $date_array[0] += 86400; } }else{ $newsshow[date("j", $datanewsCalendar[$count]["date"])] .= '
  • '.substr($datanewsCalendar[$count]["name"],0,15).' ...
    • '; } /*$datanewsCalendar[$count] = $row; $newsshow[date("j", $datanewsCalendar[$count]["date"])] .= '
  • '.substr($datanewsCalendar[$count]["name"],0,15).' ...
    • ';*/ } ?> Hong Kong Air Cadet Corps


    );" class="black"> );" class="black">
    "; for($i=1; $i<=$num; $i++) { if($i==1) { for($j=0; $j "; } } if(date("w",mktime(0, 0, 0, date("m", $now) , $i, date("Y", $now))) == 6) { echo ""; echo ""; } else if(date("w",mktime(0, 0, 0, date("m", $now) , $i, date("Y", $now))) == 0) { echo ""; } else { echo ""; } } echo ""; ?>
    Sunday Monday Tuesday Wednesday Thursday Friday Saturday

    ".$i."

    "; if($eventshow[$i] != "") { echo "

      ".$eventshow[$i]."

    "; } if($newsshow[$i] != "") { echo "

      ".$newsshow[$i]."

    "; } echo "

    ".$i."

    "; if($eventshow[$i] != "") { echo "

      ".$eventshow[$i]."

    "; } if($newsshow[$i] != "") { echo "

      ".$newsshow[$i]."

    "; } echo "

    ".$i."

    "; if($eventshow[$i] != "") { echo "

      ".$eventshow[$i]."

    "; } if($newsshow[$i] != "") { echo "

      ".$newsshow[$i]."

    "; } echo "