[Daniel]

Greettttings! I'm trying to get this working... it should pull up and display users from a secondary user group ("9") on a vB page.

$veteran_members = $db->query("
	  SELECT userid, usergroupid, 
	  IF(usergroupid==9, usergroupid, usergroupid) AS usergroupid, 
	  username, lastpostid, posts, joindate
	  FROM " . TABLE_PREFIX . "user AS user
    ORDER BY joindate ASC
	  LIMIT $count
	  ");

(This is the only part of the code which I need help with. It is modified from the original code which showed new members, seen below)