Well, I got this far but I can't get it to pull the names of the people the user has given reutation to. Can anyone tell me why this code isn't working?
PHP Code:
$recipients=$DB_site->query("
SELECT reputation.userid,user.username
FROM " . TABLE_PREFIX . "reputation
LEFT JOIN " . TABLE_PREFIX ."user ON user.userid=reputation.userid
WHERE reputation.whoadded='".$reputation['userid']."'
ORDER BY username ASC
");