Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    MYSQL




Query To Show Users Who Haven't Logged In


Since this would seem to be an easy question, I'll assume it's been
answered here before. On a site of mine, every time someone logs in,
authenticating against 'Users', a record is inserted into a table
called 'UserLog'. The two tables below represent the basic structure
of what I'm working with.


Table: Users
--------------------------
ID | Username | Password |
--------------------------
1 | syeargin | testpass |
2 | rdoe | passwd |
3 | jdoe | demo |
4 | jking | passwd |
5 | badams | demo |
--------------------------

Table: UserLog
-------------------------------------
ID | Username | LoggedIn |
-------------------------------------
1 | rdoe | 2004-08-24 12:16:33 |
2 | syeargin | 2004-08-24 12:14:33 |
3 | rdoe | 2004-08-24 12:16:33 |
4 | jking | 2004-08-24 12:16:33 |
6 | jking | 2004-08-24 12:16:33 |
-------------------------------------

My goal is to create a query that returns:

RecordSet: NoLogin
---------------
ID | Username |
---------------
3 | jdoe |
5 | badams |
---------------


My native language for the web site is PHP, but I think I've got a
handle on any other coding needs. All I need is a query.




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread

    Copyright © 2005-08 www.BigResource.com, All rights reserved