Code: Select all
$query = 'SELECT DISTINCT a.username' .
' FROM #__session AS a' .
' WHERE client_id = 0' .
' AND a.guest = 0';
Code: Select all
$query = 'SELECT DISTINCT u.name' .
' FROM #__session AS a' .
' INNER JOIN #__users AS u ON u.id = a.userid' .
' WHERE a.client_id = 0' .
' AND a.guest = 0';
Code: Select all
<?php echo $name->username; ?>
Code: Select all
<?php echo $name->name; ?>