Hey,
I am designing a website. I was wondering in the admin panel how would I display users from newest to oldest.
Display users from Newest to Oldest
Moderator: General Moderators
Re: Display users from Newest to Oldest
Assuming you store registration date in the database, something like this should suffice:
Code: Select all
SELECT username FROM tablename ORDER BY join_date DESC-
litebearer
- Forum Contributor
- Posts: 194
- Joined: Sat Mar 27, 2004 5:54 am
Re: Display users from Newest to Oldest
in the event of no join date, AND presuming you have an auto increment id field, ordering by id desc will also work