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

MySQL Does not UPDATE- SQLString Problem
vb Syntax (Toggle Plain Text) 1. SQL = "UPDATE sampletable SET column1 = 'C1sample1'"

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Get dump of MySQL DB from Live Site
I'm after an easy, but secure way of generating and importing a MySQL dump from a remote server.

Stopped working!
So I had to change some stuff, none of it major. Stuff like the extension_dir and such. BEFORE I did

problems with php variables in mysql query
i can't seem to get the following query to work.

select $q1c from $vote_rate where id = $re

Checking if multidimensional array is empty?
I have a for with multiple test input fields. Specifically the user submits multiple names and ages

PHP Surveys
I really would like some advice.

If you have a client come to you asking for a survey to be d

MySQL issue
I am taking sentences through a form on page. Then checking some condition and trying to insert them

Bit manipulation program with binary operations
My homework is to create a program to scan in and add binary numbers and print them like so

Buggy registration system
Hey, I just started scripting in PHP, and I ran into a few problems.
Code: <?php
includ