MyBB Community Forums

Full Version: List queries
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
Ohh thanks guys!

I'll try it immediately!

Well I've current got this:

www.deltacommanders.com/forum/dcmembers.php

It says in all members -> 7

I'd like to want it shows after each table the num of users

And in the bottom, the total of users listed.

And again, I am using a 'while' and this query:
$memberlevel = $db->query("SELECT * FROM `".TABLE_PREFIX."usergroups` WHERE gid IN (8,9,10,12,13,14,15,20) ORDER BY gid ASC");

I can send the whole code in PM, if someone is wanting to support me fully:3
Would be awesome!


Thanks

PPS. A user has started his name with an $, and you see in the list there is 1 spot which is blanco. The user used to stand there, but as the $ defines a variable, it causes a little bug.
(I think this is a security risk too?)

To list the things:
1. Show # of users in a group
2. Show total # of users
3. Fix the $ thingie

Would be great if someone is able to help me! I'm still a newbie though
Pages: 1 2