SELECT * FROM guestbook Order BY MessageID Desc
SELECT Max(MessageID) AS MaxID FROM guestbook
SELECT * FROM guestbook WHERE MessageID = #MaxID#
Click here
to leave a message.
Thanks for signing our guestbook
#Name#
. Your entry is below.
Name:
#Name#
Date:
#DateFormat(DateWritten, 'mm/dd/yy')# - #TimeFormat(DateWritten, 'hh:mm tt')#
#Message#
Click here
to leave
a
another
message.
Administration
Name:
Message:
INSERT INTO guestbook (Name, Email, Message, DateWritten, IPAddress, Offensive) VALUES ('#Form.Name#','#Form.Email#','#Form.Message#',#Now()#,'#CGI.Remote_Addr#','0')