Page 1 of 1

FEU - Newest users

Posted: Sun Feb 10, 2008 10:26 pm
by fritzfs
Hello guys,
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);