, Guest!
Already a Member? Login or Register.





Menu



Clients



Showcase



Rate FlexCMS

ScriptSearch.com Rating:

Hotscripts Rating
Excellent!
Very Good
Good
Fair
Poor

Scripts.com Rate Script!


FlexCMS eNews

To subscribe to our enewsletter, please enter your email address in the box below and click the "Subscribe" button.


Note:  You may easily remove yourself from the newsletter list at any time by following the instructions included with every mailing.

LATEST DEVELOPMENT NEWS:  FlexCMS 2.5 has been released!!! Click here to read the official announcement!

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: 158
 
Total Members & Newest Member BlockJuly 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
 

Post Message 




All Contents, Code, Scripts and Technologies Copyright 2003-2007 FlexCMS.
All Rights Reserved. Software License Agreement

Processing Time: 0.09056 seconds.
 

Powered By FlexCMS
Powered By FlexCMS


Valid CSS!