Database Query: COUNT(*)

[Kyttias]

Thanks for all the help over aim, HoF! I really appreciate it and I learned a lot of new things.

For anyone interested in more things to modify their stats page with, this will list the 10 newest users:

PHP Code:

/* Newest Users */
        $document->add(new Comment("<h4>Newest Users</h4>", FALSE));
        $newest_ten_users = $mysidia->db->select("users", array("username"), "1 ORDER BY username DESC LIMIT 10");
        while($username = $newest_ten_users->fetchColumn()){            
            $n_order++;     
            $document->add(new Comment("<b>{$n_order}.</b> <a href='../../profile/view/{$username}'>{$username}</a>"));
        }