UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Looking for Sql command

Can someone give me the command to check for any members that are not assigned to any group?

Thanks

Musky

select * form w3t_Users where U_Groups ="";

That says "give me all the information you have on all users who's groups entry is blank."

That what you're looking for?

You also might want to try

SELECT * FROM w3t_Users WHERE U_Groups = '-'

As sometimes users with no groups end up with just the separator dash in there.

I tried both of those but got error messages.

Onw of you guys said to use "FORM" in the command and one of you said to use "FROM" in the command. Is that correct??

Yes, it should be "FROM". Also in Dave's it should be two single quotes. ' followed by '


You also could try:

SELECT * FROM w3t_Users WHERE U_Groups LIKE '-' OR U_Groups = ''


(note those are all single quote marks. ' )

ah, you're right. I read it twice and still didn't see the form. <img src="https://www.ubbcentral.com/boards/images/graemlins/frown.gif" alt="" /> Thanks, Josh.

S'ok, I've spent hours debugging code I've written only to discover I've typo'd something like that. LOL