nemanja
New Member
At the moment I use the code below and when i want to display Username i got number (23 - userid from notes table).
How can I get his Username in view (exmp. Jhon Doe)?
Code:
$idiscCode = '{client___id}';
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query
->select('note, date_time, userid')
->from('map_notes')
->where('map_id = ' . $db->quote($idiscCode))
->order($db->quoteName('date_time') . ' DESC');
$db->setQuery($query);
$iused = $db->loadObjectList();
foreach ((array)$iused as $row)
{
$list[] = "<li>" . $row->userid . "<br /><br />" . $row->date_time . "<br /><br />" . $row->note . "<br /><br /></li>";
return "" . implode(array_filter($list)) . "";
}
How can I get his Username in view (exmp. Jhon Doe)?
Code:
$idiscCode = '{client___id}';
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query
->select('note, date_time, userid')
->from('map_notes')
->where('map_id = ' . $db->quote($idiscCode))
->order($db->quoteName('date_time') . ' DESC');
$db->setQuery($query);
$iused = $db->loadObjectList();
foreach ((array)$iused as $row)
{
$list[] = "<li>" . $row->userid . "<br /><br />" . $row->date_time . "<br /><br />" . $row->note . "<br /><br /></li>";
return "" . implode(array_filter($list)) . "";
}
Last edited: