|
 |
Due to the volume of spam happening on our forums, posting is now restricted to verified members only. If you're not verified, drop us a note with your username.
|
|
Home > FlexCMS Support Forum > User Help > Code Snippets > Total Members & Newest Member Block
FlexCMS Support Forum
Total Members & Newest Member Block
Started July 13, 2005 @ 11:36am by otter
|
Post Message |
otter
Administrator
Posts: 177 |
|
|
| Total Members & Newest Member Block | July 13, 2005 @ 11:36am | Ever wanted to display the total number of members your FlexCMS site has registered? Or how about displaying the newest member in a block?
Here's how you can do both:
1. Create a new block
2. Cut and paste the following code into the Custom Block Contents area:
Code
$query = "select count(RecordNumber) as UsersCount from `core-Users`";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
print 'Members: '.$row['UsersCount'];
$query = "select * from `core-Users` order by RecordNumber desc limit 1";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
print '<br><br>Newest Member: <a href="'.$MainURL.'/profile/'.$row['Username'].'.html" class="BlockColors">'.$row['Username'].'</a>'; |
|
3. Check the Process PHP Code? box and save your block.
Enjoy!
otter
ONLINE TRAINING CLASSES FOR FLEXCMS IN MAY: FlexCMS Basics (101), Sat., May, 15, 2010 & FlexCMS Blocks (Mon., May 10, 2010). |
|
|
|
|
|
|
|
|
|
| MEMBERS
|
|
|
