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
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Who's Online Now
2 members (Gizmo, 1 invisible), 901 guests, and 169 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240501)