Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Jawz]

i want to make a latest member code

i have:

Code: [Select]

echo "Latest Member: <a href='viewuser.php?u={$r['username']}";

but it doesn't show the latest member can someone please help

[Cronus]

Last member to signup?

[Danny696]

try this:

Code: [Select]

<?php // colours only.
$r = $db->fetch_row($db->query("SELECT userid, username FROM users ORDER BY userid DESC LIMIT 1"));
echo sprintf("Latest member: <a href='viewuser.php?u=%u'>%s</a><br />", $r['userid'], $r['username']);


[Jawz]

thanks

[Danny696]

You wernot definig what $r was thats what i use to do, thought it was already there.