Getting a members name from their ID?

[AlternativeNick]

hello, im just wondering if its possible to get a members name from there ID using SSI.php.

i know $context['user']['name'] will give the name of the current user, but how can i get it from a specific ID?

[niko]

By running MySQL query

$request = db_query("
SELECT memberName, realName
FROM {$db_prefix}members
WHERE ID_MEMBER = <id>
LIMIT 1", __FILE__, __LINE__);
list ($username, $realname) = mysql_fetch_row($request);


or use LoadMemberData(<id>, false, 'minimal') after this you can access $user_profile[<id>]['memberName'] etc...

More info about LoadMemberData

[kL]

why do you need to specify the idt wice?

[winrules]

why do you need to specify the idt wice?

You don't.