Jump to the post that solved this thread.
Solved: 6 Years, 5 Months, 1 Week ago Total Members of a group.
#9
Solved: 6 Years, 5 Months, 1 Week ago
(2015-06-22, 12:03 PM)Ad Bakker Wrote: I think that Akay's statement is correct, for usergroup 8 it is then:


$count = $db->fetch_field( $db->query( "SELECT COUNT(*) as numberofmembers FROM ".TABLE_PREFIX."users WHERE `usergroup` = 8 "), 'numberofmembers' ); 

Where I had to correct another small typing error by adding a double quote just after the 8 of the usergroup.

Does anyone know how to do this with additional usergroups as well?
> SELECT finger FROM hand WHERE id='3'
Reply
Jump to the post that solved this thread.


Messages In This Thread
Total Members of a group. - by Nasyr - 2015-06-20, 08:53 PM
RE: Total Members of a group. - by Lektz - 2015-06-21, 12:56 AM
RE: Total Members of a group. - by mikeorman - 2015-06-21, 02:22 AM
RE: Total Members of a group. - by Sazze - 2015-06-21, 08:53 AM
RE: Total Members of a group. - by Ad Bakker - 2015-06-21, 10:20 AM
RE: Total Members of a group. - by Nasyr - 2015-06-21, 05:02 PM
RE: Total Members of a group. - by Sazze - 2015-06-22, 11:52 AM
RE: Total Members of a group. - by Ad Bakker - 2015-06-22, 12:03 PM
RE: Total Members of a group. - by Kiddo Monster - 2018-04-26, 07:07 AM
RE: Total Members of a group. - by isoldehn - 2017-11-06, 07:44 PM
RE: Total Members of a group. - by maan2112 - 2018-04-27, 07:03 PM
RE: Total Members of a group. - by effone - 2018-04-27, 09:28 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)