Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
Looking for SQL command
#39586 02/07/2004 12:15 AM
Joined: Jun 2006
Posts: 167
Musky
Offline
member
Musky
member
Offline
Joined: Jun 2006
Posts: 167
I want to check and see what members on my boards are NOT assigned to any group.

Can you tell me what the SQL command is for this?

Thanks

Musky


How's all this "hopie-changie" working out for you???
Re: Looking for SQL command
#39587 02/07/2004 12:22 AM
Joined: Jun 2006
Posts: 742
Charlotte, NC
JoshPet Offline
enthusiast
JoshPet
enthusiast
Offline
Joined: Jun 2006
Posts: 742
Charlotte, NC
SELECT U_Username
FROM w3t_Users
WHERE U_Groups = ''
OR U_Groups = '-'

Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com
Re: Looking for SQL command
#39588 02/07/2004 1:43 AM
Joined: Jun 2006
Posts: 167
Musky
Offline
member
Musky
member
Offline
Joined: Jun 2006
Posts: 167
Thanks Josh:


How's all this "hopie-changie" working out for you???

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
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
spam issues
by ECNet - 03/19/2024 11:45 PM
Who's Online Now
1 members (Nightcrawler), 963 guests, and 210 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 20230217)