I was wondering how could I make a thing that displays the newest member? like IPB has at the bottom. Thanks.
Newest Member
Started by Chris., Oct 14 2006 08:56 PM
3 replies to this topic
#1
Posted 14 October 2006 - 08:56 PM
#2
Posted 14 October 2006 - 08:59 PM
Quickest and easiest way would be to use IPBSDK.
With that you can do ever so much more as well, lol.
Now, if you are talking about using your own member system and displaying newest member, simple as using a basic MySQL query like so.
With that you can do ever so much more as well, lol.
Now, if you are talking about using your own member system and displaying newest member, simple as using a basic MySQL query like so.
$newest_member = mysql_query("SELECT * FROM `members` LIMIT 1) or die(mysql_error());
#3
Posted 15 October 2006 - 02:21 AM
That would display the very first member 
Matt
$newest_member = mysql_query("SELECT * FROM `members` ORDER BY `id` DESC LIMIT 1) or die(mysql_error());
Matt
#4
Posted 15 October 2006 - 01:57 PM
thanks, worked perfect
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
