help with this please

Posted on Thursday 29th May 2008 at 12:14 PM
Nathan
Nathan's Avatar
how would i display the newest 5 members with links to there profile ?
Posted on Thursday 29th May 2008 at 02:09 PM
darklight19
darklight19's Avatar
sort by id?
Posted on Thursday 29th May 2008 at 02:12 PM
darklight19
darklight19's Avatar
with the limit of 5
Posted on Friday 30th May 2008 at 04:15 AM
Nathan
Nathan's Avatar
yeah correct
Posted on Friday 6th June 2008 at 07:01 AM
SkillMaster
SkillMaster's Avatar
Code
$select = mysql_query("SELECT * FROM `members` ORDER BY `id` DESC LIMIT 0, 5");
while ($user = mysql_fetch_array($select)) {
echo ("- $user[username]<br />");
}
Login or register to respond to this forum topic.