here's another UDT that will display a list of 10 newest members.
Code: Select all
global $gCms;
$db = &$gCms->db;
$result = array();
$q = "SELECT username FROM `cms_module_feusers_users` ORDER BY createdate DESC LIMIT 10";
$dbresult = $db->Execute( $q );
if( $dbresult ) {
while ( $row = $dbresult->FetchRow() ) {
array_push($result, $row['username']);
}
}
echo implode(",", $result);