Newest & Total Members
This is the code for RMB-Scripting User System.This script shows how many members there are in the database and the last member in the database.
PHP Code
1 2 3 4 5 6 7 8 9 10 11 12
<?php
include("config.php");
//Query database & Counts the rows in the members database
$count = mysql_num_rows(mysql_query('SELECT * FROM `members`'));
echo $count; //Displays the total members
$new = mysql_fetch_array(mysql_query("SELECT * FROM `members` ORDER BY `id` DESC LIMIT 0, 1")); //Gets the newest member
echo "Newest User: " . $new[username]; //Displays the newest member
?>
Code split up
PHP Code
1 2
<?php
include("config.php");
PHP Code
1
$count = mysql_num_rows(mysql_query('SELECT * FROM `members`'));
PHP Code
1
echo $count;
PHP Code
1
$new = mysql_fetch_array(mysql_query("SELECT * FROM `members` ORDER BY `id` DESC LIMIT 0, 1"));
DESC is the order type (descending) what gets the last results to display first and the new ones last. Then limit only allows 1 result, Which is our last member.
PHP Code
1 2
echo "Newest User: " . $new[username];
?>
Updated by DanielXP
Posted on Sunday 17th August 2008 at 08:36 PM
oh sorry limit3 edit to limit 5 :-)
Posted on Sunday 17th August 2008 at 08:35 PM
<?php
include("config.php");
//Query database & Counts the rows in the members database
$count = mysql_num_rows(mysql_query('SELECT * FROM `members`'));
echo $count; //Displays the total members
$new = mysql_fetch_array(mysql_query("SELECT * FROM `members` ORDER BY `id` DESC LIMIT 3")); //Gets the 5 newest member
echo "Newest User: " . $new[username]; //Displays the newest member
?>
include("config.php");
//Query database & Counts the rows in the members database
$count = mysql_num_rows(mysql_query('SELECT * FROM `members`'));
echo $count; //Displays the total members
$new = mysql_fetch_array(mysql_query("SELECT * FROM `members` ORDER BY `id` DESC LIMIT 3")); //Gets the 5 newest member
echo "Newest User: " . $new[username]; //Displays the newest member
?>
Posted on Sunday 17th August 2008 at 05:03 PM
How can i show about 5 newest members ?? is that possible ?
plz comment back :)
plz comment back :)
Posted on Thursday 31st May 2007 at 03:40 PM
soz double post LoL cancel plz :S
Posted on Thursday 31st May 2007 at 03:40 PM
oops missed the page xD
Posted on Thursday 31st May 2007 at 03:39 PM
oops missed the page xD
Posted on Thursday 31st May 2007 at 03:38 PM
he means that you must control if the table is 'members' or else
Posted on Wednesday 30th May 2007 at 09:41 PM
It works now. Thank you very much guys ;)
Posted on Wednesday 30th May 2007 at 07:37 PM
For the way I made it, it was for members, but I guess gbt changed it.
Either way if you change the users to members and you are using RMB-scriptings member system.
Either way if you change the users to members and you are using RMB-scriptings member system.
Posted on Wednesday 30th May 2007 at 07:18 PM
Sry, didn't know the tags XD
Here again in the tagbox ;)
Here again in the tagbox ;)
PHP Code
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
<?php
include('config.php');
// Query database
$count_sql = 'SELECT * FROM members';
$count_result = mysql_query($count_sql);
//gets the number
$count = mysql_num_rows($count_result);
echo"$count"; // displays the total members
$new = mysql_fetch_array(mysql_query("SELECT * FROM `members` ORDER BY `id` DESC LIMIT 0, 1")); // Gets the newest member
echo "Newest User: " . $new[username]; // displays the newest member
?>