Page 1 of 1

Display users from Newest to Oldest

Posted: Thu Feb 23, 2012 3:44 pm
by Ruthless.
Hey,

I am designing a website. I was wondering in the admin panel how would I display users from newest to oldest.

Re: Display users from Newest to Oldest

Posted: Thu Feb 23, 2012 3:57 pm
by Celauran
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

Re: Display users from Newest to Oldest

Posted: Thu Feb 23, 2012 8:27 pm
by litebearer
in the event of no join date, AND presuming you have an auto increment id field, ordering by id desc will also work