Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
SQL Query Needed
#129495 07/07/2006 6:33 PM
Joined: Jun 2006
Posts: 73
C
cdavis
Offline
journeyman
cdavis
journeyman
C Offline
Joined: Jun 2006
Posts: 73
I need to find the display name of every user who has posted in the last 2 years (after July 7, 2004).

I tried this, but it didn't work:
Code
SELECT U_LoginName FROM w3t_users WHERE U_LastPost >= 1089209511;

Last edited by kernel-panic; 07/07/2006 6:39 PM.
Re: SQL Query Needed
#129496 07/07/2006 6:55 PM
Joined: Jun 2006
Posts: 73
C
cdavis
Offline
journeyman
cdavis
journeyman
C Offline
Joined: Jun 2006
Posts: 73
Does this look right?
Code
SELECT U_LoginName FROM w3t_users WHERE U_LastPostTime > 1089176399;
Re: SQL Query Needed
#129497 07/07/2006 7:21 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
R
Rick Offline
Former Developer
Rick
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
Your last one looks correct, however if you are looking for the display name then you'd want to change U_LoginName to U_Username

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Having issues going from 7.5.5. to 8X
by Mors - 10/22/2026 5:32 PM
Slow Queries - Any Ideas?
by BellaOnline - 10/16/2026 8:34 PM
Selling a Forum?
by ECNet - 10/10/2026 2:54 PM
Who's Online Now
2 members (Gizmo, 1 invisible), 914 guests, and 155 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20261026)