Count of Users under one admin

Question

4.00/5 (1 vote)

See more:

hello,
how can i get total number of users under one admin. i have added various users under different admins in a single table.
i want to show every admin on his page, how many users are added by him. i want to get total count of users under that particular admin in a label on admins homepage.

Posted 20-Nov-12 0:46am

Jasbeer Singh

Add a Solution

Comments

faisal23 20-Nov-12 6:56am

Try simple count query......

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sinhasourabh · Answer 1 · 2012-11-20T00:57:00

If you want to see the count of all users under all admins use this

SQL

SELECT Admin, COUNT(username) as "Number of employees"
FROM Users
--WHERE salary>  25000 -- provide some appropriate where cluase
GROUP BY Admin;

if you wish to show list of users under single admin you need to brushup your SQL basics. the simplest query ever.

SQL

SELECT username
From Users
WHERE Admin = 'xyz'

Make sure that your are not copy the entirecode, but along with that provide correct colom and table name

OriginalGriff · Answer 2 · 2012-11-20T00:55:00

Solution 2

Without knowing a lot more about your database structure, it will be something like:

SQL

SELECT COUNT(Users) FROM MyTable WHERE Admin='MyAdmin'

Where Users and Admin are columns in your table.

Posted 20-Nov-12 0:55am

OriginalGriff

Comments

Jasbeer Singh 20-Nov-12 7:13am

i did it already , but how can i retrieve this count in a label.

Krunal Rohit · Answer 3 · 2012-11-20T00:52:00

Solution 1

Try to do this using multiple tables like SuperAdminTable have foreign key of all the AdminTable, which will have foreign key of UsersTable.. so achieve this using Relationship concept..

Posted 20-Nov-12 0:52am

Krunal Rohit

Updated 20-Nov-12 0:53am

v2

Count of Users under one admin

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Count of Users under one admin

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us