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:

PHP 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]

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

[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.
[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'].

[OnyxChase]

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