This one seems harder than it probably is, I basically want to display the 6 most recent members of my website like so:

SELECT * FROM TBLUSERS ORDER BY [DATE] DESC LIMIT 6

I think x.x

I like your thinking but assuming i'll get a few people join the site each day is there anyway to display realtime new members?

Originally Posted by l3lueMage

SELECT * FROM TBLUSERS ORDER BY [DATE] DESC LIMIT 6

I think x.x

Just change [DATE] to the userID (auto-increment primary key).

PHP Code:

$query = "SELECT * FROM users ORDER BY uid DESC LIMIT 6";

$query = mysql_query($query);

while($users = mysql_fetch_assoc($query)) {

echo $users['username'] . ", ";

} 


Something like that too, would work, for actually echoing the data.

I think he need to display the latest visitors to the site.It can be down by adding a log table and using the format of the above query