Someone

// lookup featured troop info
$query = 'SELECT name, picture FROM users WHERE uid = "$troop_for_points"';
$row = mysql_query($query) or die(mysql_error());
list($featured_troop) = mysql_fetch_array($row);
$_SESSION["selected_troop_screenname"] = $featured_troop["name"];