This would be similar to the "Welcome our newest member:" feature. The sql statement for that is:
'## Forum_SQL - Get newest membername and id from DB
strSql = "SELECT M_NAME, MEMBER_ID FROM " & strMemberTablePrefix & "MEMBERS WHERE M_STATUS=1 AND MEMBER_ID > 1"
strSql = strSQL & " ORDER BY M_DATE desc;"
set rs = my_Conn.Execute(strSql)
if not rs.EOF then
NewMember_Name = ChkString(rs("M_NAME"), "display")
NewMember_Id = rs("MEMBER_ID")
else
NewMember_Name = ""
end if
It would be the same except, of course, you'd change the "select" fields and then order by "G_DATE" which is the date field in the Guestbook table.
Hope this helps a little
<-- Eric -->
InsideWaco.com