majocmatt Posted April 5, 2007 Share Posted April 5, 2007 I have a table with date of births and I'm trying to select the next 3 upcoming birthdays and display them. I'm trying to use this ORDER BY clause but it seems not to want to listen to me. Can anyone help me figure out why? ORDER BY DATE_FORMAT('profile_dob', '%m-%d') > DATE_FORMAT(NOW(), '%m-%d') DESC, DATE_FORMAT('profile_dob', '%m-%d') LIMIT 3 Currently, it returns them in no particular order at all.. haha. Here is what I'm getting as the result: Sep 25, May 25, Sep 5, July 1, Sep 21, Mar 18 Any suggestions would be great.. thanks! Quote Link to comment https://forums.phpfreaks.com/topic/45760-trying-to-select-upcoming-birthdays-from-a-dob/ Share on other sites More sharing options...
gluck Posted April 5, 2007 Share Posted April 5, 2007 use the checking or comparision in a where clause and then use order by at the end. Quote Link to comment https://forums.phpfreaks.com/topic/45760-trying-to-select-upcoming-birthdays-from-a-dob/#findComment-222280 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.