Oldest / youngest user on my board?

[Wachtmeister]

Hello,

maybe someone did this before... I would like to know which are my oldest and my youngest users. I cannot sort the userlist this way and someone told me, that i need a query.

Does someone has this query into his pocket right now?

Regards, Wachtmeister

[Lats]

Try these...

Youngest:

SELECT 
    username, 
    birthday_search, 
    year( current_date ) - year( birthday_search ) AS age
FROM 
    user
WHERE 
    year( current_date ) - year( birthday_search ) < 18
AND
    year(birthday_search) > 1900
AND
    year(birthday_search) < 2010
ORDER BY
    age ASC

Oldest:

SELECT 
    username, 
    birthday_search, 
    year( current_date ) - year( birthday_search ) AS age
FROM 
    user
WHERE 
    year( current_date ) - year( birthday_search ) > 40
AND
    year(birthday_search) > 1900
ORDER BY
    age DESC

[Wachtmeister]

Great !

THANK YOU