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

retrieving policy name inside the function called by this particular policy
Hi there,

I've playing around with dbms_rls package, trying to set up some security repo

need help in mysql_num_rows()
please tell me what i am doing wrong in this query. it displays this error

Code: Warning: mys

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

reorder sql query
ok so i have this very simple code:
Code: $query = "SELECT search_keywords, COUNT(search_key

error help - Dynamic Image
I've been working on making my site less cluttered in the directories and more secure lately. In an

PHP - MySQL Fail
My PHP code will only execute the first part of my code...

Code: <?php

sessio

WHYISNT THIS MYSQL STATEMNT NOT WORKING? (php)
caps because its absolutely rediculous.
i dontunderstand why its not working. there is a column c

How can I Compare two xml documents?
Hi all,

I am doing a POC for my project and I am using XE database 10g version.

Can't seem to capture a variable in a chained select
I'm *this* close to having a chained select running but for some reason it doesn't seem to be pickin

php title problem
Hi,

I am having a problem managing my page title with PHP.

Currently I have my <