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:
How would you pull more than one username and userid? Like a list.
Code:
$referrals = $db->query_first(" SELECT username, userid FROM " . TABLE_PREFIX . "user WHERE referrerid = '".$userinfo['userid']."' "); $userinfo['referralname'] = $referrals[username]; $userinfo['referralid'] = $referrals[userid];
Comment