SELECT * FROM Calendar WHERE Status = 1 AND GlobalEvent = 1 AND End_Date > getdate() ORDER BY Start_Date SELECT * FROM Calendar WHERE Status = 1 AND GlobalEvent = 1 AND End_Date < getdate() ORDER BY Start_Date

Calendar

Featured event: the 11th International Coral Reef Symposium to be held at the Greater Fort Lauderdale/Broward County (Florida) Convention Center, July 7-11, 2008.

Every four years the International Coral Reef Symposium (ICRS) convenes as a major scientific conference to provide the latest knowledge about coral reefs worldwide. Natural scientists, resource managers and users, conservationists, economists, and educators meet together to advance coral reef science, management, and conservation. The International Society for Reef Studies (ISRS), the largest society focused on coral reefs worldwide, officially sanctions ICRS meetings. www.nova.edu/ncri/11icrs

~~~~~

The next ICRI GM will be held on July 12-13, 2008 in Fort Lauderdale, Florida. The venue will be the ICRS Conference Centre.

  • Coming Events: (You can submit a new calendar entry. You need to be logged in.)
      SELECT TOP 1 Country_Name FROM Countries WHERE CountryID = SELECT TOP 1 KioskName FROM Kiosks WHERE UID =
    1. #EventTitle#
      (#Current_Kiosk#)
       #City#, #Current_Country#: #DateFormat(Start_Date, 'mmmm d, yyyy')# - #DateFormat(End_Date, 'mmmm d, yyyy')#
      Contact: #ContactName##ContactName#
       #Abstract#


    There are no coming events

    Show Past Events

    Hide Past Events
      SELECT TOP 1 Country_Name FROM Countries WHERE CountryID = SELECT TOP 1 KioskName FROM Kiosks WHERE UID =
    1. #EventTitle#
      (#Current_Kiosk#)
       #City#, #Current_Country#: #DateFormat(Start_Date, 'mmmm d, yyyy')# - #DateFormat(End_Date, 'mmmm d, yyyy')#
      Contact: #ContactName##ContactName#
       #Abstract#