Last 10 users code

[danx30]

What I'm trying to do is have a section of my website to list the last 10 users of the page.  The users are saved into a mysql database.  There are thousands of users but only want it to show the last 10.

 

For some reason this is stumping me.  I'm just not sure how to approach it.  Any help would be appreciated.

[simshaun]

Last 10 users that *what*?  Last 10 who have logged in?  Update a timestamp in the db upon login and run a query such as SELECT id FROM users ORDER BY last_login DESC LIMIT 10.

[Stuie_b]

if its a case of the last 10 registered users, you could run a query and limit it to 10 for example

 

<?php
$qh = mysql_query("SELECT * FROM members_table WHERE active='1' LIMIT 0,10");
while($ret = mysql_fetch_array($qh)){
echo $ret['username'];
}
?>

 

Stuie

 

[danx30]

Thanks, I figured out how to do it.  You helped me get unstuck.