An SQL Query needed

[Imran]

Hello

Can any one provide me an sql query for a selective users from a selecive usergroup ?

I mean , I want Users of gid 6 and list them separately on another page.

Help needed

Regards

[RateU]

Maybe something like this:

SQL Code

$query = $db->simple_select('users','*','usergroup="6"');

---

[Imran]

Then how to count them ?

PHP Code:

$query = $db->simple_select('users','*','usergroup="6"'); $count = $db_num_rows($query);

---

^ Is it right ?

[RateU]

PHP Code:

$count = $db->num_rows($query);

---

[Imran]

Yes, Thanks