select * from states select * from months select * from years select distinct racetype from subevent Trail Run Calendar
Month: Year: State: Race Type  
Race Directors | Printable Calendar

 

select * from states where stateshort = '#url.state#' select * from states where stateshort = '#form.state#'
 #titledisplay# Search Again    Show all events  
select * from event Where lstate = '#getstate.statelong#' eventid >= 0 eventid >= 0 order by #url.sort#, caldate order by caldate select * from event where lstate = '#getstate.statelong#' and month = '#form.month#' and year = '#form.year#' and eventid >= 0 order by #url.sort#, caldate order by caldate select event.*, subevent.* from event, subevent Where event.eventid = subevent.eventid and event.lstate = '#getstate.statelong#' and event.month = '#form.month#' and event.year = '#form.year#' and subevent.racetype = '#form.type#' and event.eventid >= 0 order by #url.sort#, caldate order by caldate
Event Date City State
select monthname from months where monthnumber = '#monthcur#' #getm.monthname#
select monthname from months where monthnumber = '#monthcur#' #getm.monthname#
#gete.Eventname# #gete.displaydate# #gete.lcity# #gete.lstate#
#gete.Eventname# #gete.displaydate# #gete.lcity# #gete.lstate#
Sorry there are currently no events scheduled in this area.