Username instead of name in articles?

[johneilif]

Hello. I've searched the web a bit for some guide on how to replace the author name with author username in joomla articles in Joomla 3.. I have recently developed some sites in Both Joomla 1 and Joomla 2, but I cant figure out where and what to change in Joomla 3 to get the same effect with usernames instead of Names when it comes to articles. Does anybody know the answer for this?

[itoctopus]

In your article layout template, add the following code in the appropriate place:

Code: Select all

$db = JFactory::getDbo();
$sql = "SELECT username FROM #__users WHERE id='".$this->item->created_by."'";
$username = $db->loadResult($sql);
echo($username);