select * from events where eventTypeID = '3' and eventDate >= #fortnight#
select * from mixes where mixUploaded >= #fortnight# and isActive = 'y'
insert into messageBoard (postedBy,theMessage,postDate,posterIP)
VALUES ('#postedBy#', '#theMessage#', #postDateUK#, '#cgi.REMOTE_ADDR#')
update messageBoard
set postedBy = '#postedBy#',
theMessage = '#theMessage#',
postDate = #postDateUK#,
posterIP = '#cgi.REMOTE_ADDR#'
where postID = '#mID#'
delete from messageBoard where postID = '#mID#'
To stop random messages from computers please click HERE.
You may then add your message
Thankyou Groove-Monkey.
Please Complete All Fields
select * from messageBoard order by postDate Desc LIMIT 0,50
#postedBy# on #dateFormat(postDate, 'DD-MMM-YY')# @ #timeFormat(postDate, 'HH:MM')# says:
#replace(theMessage,'#Chr(10)##Chr(13)#','
',"All")#
(
edit
|
delete
)
select * from messageBoard where postID = '#mID#'
select * from messageBoard where postID = '#mID#'
Are you sure you want to delete this post?
#postedBy#
#theMessage#
No
|
Yes