[Resolved] HELP - select statement

[kpowning]

Is there a better way to do this?

SELECT COUNT(*) FROM " . TABLE_PREFIX . "user
                       WHERE referrerid > 0 AND usergroupid!=1 AND usergroupid!=3 AND usergroupid !=7

Do you have to specify each time with the usergroupid what numbers you dont want to be included like I have above, or is there an easier way to exclude these numbers without writing the script like I have it??

Thanks for any help on this... 🙂

[vornn]

It all depends of what you are tring to achive.

from the code you have posted, one would assume (probably wrongly) that you are tring to list the uses, but not users in some groups.

What you could do is process your data at your echo statement.

for example:

get data from database

if group = #
do something
else if

etc.

this however, would depend on how many groups you have and might be a nightmare to sort in the future.

we'll help you all we can

hope this helps...

🙂

[xblue]

might not be a big improvement, but I find it easier to read (and extend): instead of

AND usergroupid!=1 AND usergroupid!=3 AND usergroupid !=7

AND usergroupid NOT IN (1,3,7)

should work as well

[kpowning]

thanks people works like a champ