[SOLVED] display last 5 users registerd

[stelthius]

Hello guys,

 

I have made a little code to display the last user registered now i want to alter it to show the last 5 users registerd but it seems no matter how i try and do this it doesnt want to work, my snippet is below..

 

<?php
include('include/session.php');

$new = mysql_fetch_array(mysql_query("SELECT * FROM `users` ORDER BY `signupdate` DESC LIMIT 0, 1")); /* Gets the newest member */
echo "New Users : " . $new[username]; /* Displays newest member */

?>

 

 

Thanks Rick.

[premiso]

<?php
include('include/session.php');

$res = mysql_query("SELECT * FROM `users` ORDER BY `signupdate` LIMIT 5"); /* Gets the newest member */

while ($row = mysql_fetch_assoc($res)) {
    echo "New User : " . $row['username'] . "<br />"; /* Displays newest member */
}
?>

 

Should get you what you want.

[stelthius]

Thank you, nice and simple one for a change lol,

 

Thanks again Regards Rick