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
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