How would I do "Users not logged in since *** delete them"

Posted on 16th Feb 2014 07:03 pm by admin

I know how I would set this up, and delete the user roughly.
I'll create a table called "Users Status" with ID, Username, date registered, and last logged in collumns. Last Logged in will be recorded as years, and will be set on every page. I will then be checking in admin control panel, if the user has not been logged in since whatever year. Delete them.

I was wondering if this is the best way to do it? or would there be an easier way.

Thanks

Your Answer:

Login to answer

Other forums

help connecting a form to php and then emailing the form
Ok. So, I made a form, and I need help to where when submitted, I get an email with the submitted de

How many users online in the last 24-hours using time()?
I'm fairly new to PHP. I have a MySQL table called 'users' and a field called 'loggedin' which is in

mysql_affected_rows() usage
Possibly a MySQL issue, but the function that is not behaving in the anticipated way is a PHP functi

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

More pug propaganda.
http://www.youtube.com/watch?v=8Kkrmubsgf8

The commercial is definitely worth watching pug aw

need help in update query
hi
i have a dynamic form. i need help in how can i use update query when values from dynamic for

Sending an SMS Message with ASP.NET
Often times it may be a requirement for your web application to send an SMS message. Such examples w

mail with attachment problems
Hi. I have the following code:
Code: else if(file_exists("site".$timp.".zip")

HELP with mysql_real_escape_string
I'm looking to remove apostrophes completely when someone enters lyrics but don't have a clue how to