CodingForums.com - View Single Post

Celtboy · 02-24-2013, 07:24 AM

does this not do what you want?

Code:

$sql = 'SELECT username, DATE_FORMAT(join_date, "%d/%m/%y") AS join_date_str, COUNT(*)
         FROM users
         ORDER BY join_date 
         DESC
         LIMIT 5';

I may not understand what you're after.

02-24-2013, 07:24 AM	PM User \| #2
Celtboy Regular Coder Join Date: May 2002 Location: Virginia, USA Posts: 620 Thanks: 0 Thanked 6 Times in 6 Posts	does this not do what you want? Code: $sql = 'SELECT username, DATE_FORMAT(join_date, "%d/%m/%y") AS join_date_str, COUNT(*) FROM users ORDER BY join_date DESC LIMIT 5'; I may not understand what you're after.