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 aanother 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')