cant get ordering mysql results by current date ASC to work

Posted by Patrick on Stack Overflow See other posts from Stack Overflow or by Patrick
Published on 2010-04-18T17:44:43Z Indexed on 2010/04/18 17:53 UTC
Read the original article Hit count: 279

Filed under:
|

Im trying to order results ASCENDING from the current date

this is what im using now;

SELECT * FROM friends JOIN bdays 
ON bdays.user = friends.friendname 
WHERE username = $userid ORDER BY DATE_FORMAT(date, '%m %d')

any ideas?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about php