select * from states select * from months select * from years select distinct racetype from subevent INSERT INTO pcalevent (pcalemail, peventid) VALUES ('#session.email#', #session.pcale#) select * from event where eventid = #session.pcale# delete FROM pcalevent WHERE peventid = #session.pcale# and pcalemail = '#session.email#' select * from event where eventid = #session.pcale# Trail Run Personal Calendar
rows: #MAX_ROWS#
cols: #MAX_COLS#
month: #targetMonth#
year: #targetYear#
date: #bogusDate#
first day of month: #firstDayOfMonth#
days in month: #daysInMonth#
rows needed: #rowsNeeded#
  Personal Calendar
#MonthAsString(targetMonth)# #targetYear#
#session.name#  
select pcalevent.*, event.* from pcalevent, event where peventid = eventid and pcalemail = '#session.email#' and (month = '#form.month#' or month = '0#form.month#') and year = '#form.year#' and day = '#truedaychk#' and lstate = '#form.state#'
Sun
Mon
Tue
Wed
Thu
Fri
Sat
#trueDay# select * from dailyrunnerslog where username = '#session.email#' and (dateranmm = '#form.month#' or dateranmm = '0#form.month#') and dateranyy = '#form.year#' and daterandd = '#trueday#'    #getlog.distance# Miles
 #getlog.dtime#
    #getdata.eventname#

Edit Log

Log

 		 
select * from dailyrunnerslog where username = '#session.email#' and (dateranmm = '#form.month#' or dateranmm = '0#form.month#') and dateranyy = '#form.year#' Total for #MonthAsString(targetMonth)#:   #mmtotal# Miles     
select * from dailyrunnerslog where username = '#session.email#' and dateranyy = '#form.year#' Total for #targetYear#:   #yytotal# Miles     
select * from states
Trail Run Personal Calendar
To view a different month please pick a month and year.
Month Year State
Show Events
Month: Year: State: Race Type