MyBB Hacks

MyBB Hacks > Coding > An SQL Query needed
Full Version: An SQL Query needed
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Imran

06-30-2010, 05:07 AM
Hello Smile

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 Smile

Regards

RateU

06-30-2010, 06:58 AM
Maybe something like this:

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

Imran

06-30-2010, 03:37 PM
Then how to count them ?

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


^ Is it right ?

RateU

07-01-2010, 01:32 AM

PHP Code: 
$count = $db->num_rows($query);

Imran

07-03-2010, 05:08 PM
Yes, Thanks Smile
MyBB Hacks > Coding > An SQL Query needed
Reference URL's