Sorry, wrong query.
[sql]SELECT award_user.issue_id, award_user.award_id, award_user.userid, award_user.issue_reason, award_user.issue_time, user.username
FROM " . TABLE_PREFIX . "award_user AS award_user
LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid)
ORDER BY issue_id DESC
LIMIT $limit[/sql]
Replace your query with mine, then you can access the username using $row['username'].
|