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 the guestbook #Name#.  To keep this guestbook rated PG, I'll have to review your comments before I can make them live. Check back in a few hours and you should see your message live :). Thanks for visiting! Name:   #Name# Date:    #DateFormat(DateWritten, 'mm/dd/yy')# - #TimeFormat(DateWritten, 'hh:mm tt')# #Message#

Archived messages - Page 1 - Page 2

Administration

Name: Email: Message:

Archived messages - Page 1 - Page 2 INSERT INTO guestbook (Name, Email, Message, DateWritten, IPAddress, Offensive) VALUES ('#Form.Name#','#Form.Email#','#Form.Message#',#Now()#,'#CGI.Remote_Addr#','1') #Form.Name# #Form.Email# #Now()# #CGI.Remote_Addr# #Form.Message#