Hi @ all!
I have a Problem, im programming a forum for myself becose all Forums i found are not that what im looking for.
Here is my Problem: i want to Display information about the "last-login-date" of a member and i dont really think i can solve it self. Im thinking now about 10 hours and still nothing..
i have 'members' table in my access DB in this table is a field 'lastvisit_date', there the data must be stored but all i got for now is this code:
<%
if Request.Cookies("tdn")("login") = "yes" then
userid = Request.Cookies("tdn")("userid")
SQL = "UPDATE members SET "
SQL = SQL & "lastvisit_date='" & Session("Start") & "'"
SQL = SQL & "WHERE id=" & userid
Conn.Execute (SQL)
Sql = "SELECT lastvisit_date from members where id=" & userid
set rs = Conn.Execute (Sql)
lastheredate=rs("lastvisit_date")
rs.close
end if
response.write ("Your last Visit was on:" & lastvisit_date & "")
%>
And it works not so how i want. Any Time i open a new window the date in members.lastvisit_date is overwriten..
Sorry for my english its not so good..
Can u guys help me to solve this problem?
thx
Michael