Forgot Password / Register
Site Statistics
Total Members: 520
Total Tutorials: 242
Newsest User: 8884244477
Todays Unique Hits: 292
0 Users 5 Guests Online
Forum Index » PHP + MySQL » help with this please
Posted on Thursday 29th May 2008 at 12:14 PM
Nathan
templates/default/images/noavatar.png's Avatar
Active Member
how would i display the newest 5 members with links to there profile ?
Posted on Thursday 29th May 2008 at 02:09 PM
darklight19
templates/default/images/noavatar.png's Avatar
Active Member
sort by id?
Posted on Thursday 29th May 2008 at 02:12 PM
darklight19
templates/default/images/noavatar.png's Avatar
Active Member
with the limit of 5
Posted on Friday 30th May 2008 at 04:15 AM
Nathan
templates/default/images/noavatar.png's Avatar
Active Member
yeah correct
Posted on Friday 6th June 2008 at 07:01 AM
SkillMaster
templates/default/images/noavatar.png's Avatar
Senior Member
Code

$select = mysql_query("SELECT * FROM `members` ORDER BY `id` DESC LIMIT 0, 5");
while ($user = mysql_fetch_array($select)) {
echo ("- $user[username]<br />");
}