Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
SQL Query Needed
#129495 07/07/2006 2: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 2:39 PM.
Re: SQL Query Needed
#129496 07/07/2006 2: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 3: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
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Are any of these legitmate?
by Baldeagle - 09/06/2026 1:37 PM
8.0.1 Patch Changelog Discussion
by isaac - 11/26/2025 1:34 PM
Upgraded to ver8 - now can't login
by phoenix011235 - 10/24/2024 8:50 AM
Who's Online Now
1 members (Phun), 259 guests, and 127 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 20260527)