August 1st, 2000, 10:54 PM
Wondering if someone can help me. I am after something that will use a timestamp (14) from a mysql database and be able to tell how old it is based on the current time... (NOW()). I already have the field and that setup in the db but I need some code that will be able to tell how old that timestamp is. Eg. Is it more than 30 mins old. The idea behind this is to automatically log out any one who has been inactive for over 15 mins.
So the basic idea behind this is to compare NOW() with a timestamp and be able to tell how old (say to 30 mins) the timestamp is. Thanks in advance.
August 2nd, 2000, 06:52 AM