MySQL: Getting Username from UserID

[OnyxChase]

Hi guys,

I am working on a plugin which will show the latest awards recently given, but the database does not contain the member's username. It only contains the user ID. Is there a way to get the username from the userID?

Here is my current code:


$query = $vbulletin->db->query_read("
SELECT award_user.issue_id, award_user.award_id, award_user.userid, award_user.issue_reason, award_user.issue_time
FROM " . TABLE_PREFIX . "award_user as award_user
ORDER BY issue_id DESC
LIMIT $limit"
);


// reset variables
$counter = 0;
$latest_award_bits = '';

while ($row = $vbulletin->db->fetch_array($query))
{

$issueid = $row['issue_id'];
$awardid = $row['award_id'];
$userid = $row['userid'];
$reason = $row['issue_reason'];
$issuetime = $row['issue_time'];


$show['latest_break'] = $counter++;

eval('$latest_award_bits .= "' . fetch_template('latest_awards_bit') . '";');

}


Thanks, any help would be greatly appreciated!

[Dismounted]

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 ON (userid)
ORDER BY issue_id DESC
LIMIT $limit

[OnyxChase]

MMM for some reason this isn't giving me any results back... Sorry I'm new to this mySQL stuff!

[Dismounted]

Sorry, wrong query.
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
Replace your query with mine, then you can access the username using $row['username'].

[OnyxChase]

Ahh! Works great!!!! Thanks so much !!! :D Now the fun part begins .... editing the templates :)