Forum db->fetch_array question
 

If you wanted to pull more than 1 piece if info from a query, I know you use db->fetch_array, but I'm not sure how you would use it. In this example:



Code:
* *$referrals = $db->query_first("
** * * *SELECT username, userid
** * * *FROM " . TABLE_PREFIX . "user *
** * * *WHERE referrerid = '".$userinfo['userid']."' *
** *");

** *$userinfo['referralname'] = $referrals[username];
** *$userinfo['referralid'] = $referrals[userid];
How would you pull more than one username and userid? Like a list.