FEU - Newest users

Do something cool with CMS? Show us ...
This board is for 'Answers', and the discussion of answers... Not for questions.
Post Reply
fritzfs
New Member
New Member
Posts: 8
Joined: Thu Feb 07, 2008 3:39 pm

FEU - Newest users

Post 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);
Post Reply

Return to “Tips and Tricks”