Groove Monkey #dateFormat(now(), 'YYYY')# select * from events where eventTypeID = '3' and eventDate >= #fortnight# select * from mixes where mixUploaded >= #fortnight# and isActive = 'y'



select * from compEntries where compID = #compID# AND userEmail = '#userEmail#' select * from mailList where userEmail = '#userEmail#' insert into mailList (userFullName,userEmail,isDeleted) values ('#userFullName#','#userEmail#','0') insert into compEntries (compID,userFullName,userEmail,compAnswer) values ('#compID#','#userFullName#','#userEmail#','compAns#theAnswer#')
Thankyou for entering the competition.

Remember only 1 entry per competition per email address is allowed. Sorry there was an error, please complete every part of the entry form.

Sorry there was an error, you have already used this email address.

select * from competition where compStart <= #todayDate# and compFinish >= #todayDate# and subComp = 'y'
#compName#

#replace(compDesc,'#Chr(10)##Chr(13)#','

',"All")#




Competition Started: #dateFormat(compStart, 'DD MMM')# #timeFormat(compStart, 'HH:MM')# to #dateFormat(compFinish, 'DD MMM')# #timeFormat(compFinish, 'HH:MM')#

Question: #compQuestion#

A #compAnsA#
B #compAnsB#
C #compAnsC#

Your Email
Your Full Name
Join Mailing List