
Originariamente inviata da
Alhazred
Prova cambiando questo
Codice PHP:
$query = $db->getQuery(true)
->select($db->quoteName(array('a.username', 'a.time', 'a.userid', 'a.client_id')))
->from('#__session AS a')
->where($db->quoteName('a.userid') . ' != 0')
->where($db->quoteName('a.client_id') . ' = 0')
->group($db->quoteName(array('a.username', 'a.time', 'a.userid', 'a.client_id')));
con questo
Codice PHP:
$query = $db->getQuery(true)
->select($db->quoteName(array('a.name', 'a.username', 'a.time', 'a.userid', 'a.client_id')))
->from('#__session AS a')
->where($db->quoteName('a.userid') . ' != 0')
->where($db->quoteName('a.client_id') . ' = 0')
->group($db->quoteName(array('a.name', 'a.username', 'a.time', 'a.userid', 'a.client_id')));
e ad usare
<?php echo $name->name; ?>
per stampare il nome.