Question: 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?

**example**
ordering by date now, sorts the birthdays starting at january

what i need, is instead of starting the list at january, is starting it from the current date.

So, instead of;

```
January
February
March
April
May
June
July
August
September
November
December

```

It will order them like this;

```
April (current month/day)
May
June
July
August
September
November
December
January
February
March
April (all the way up to yesterday)

```

Answer: 
You could try:

```
ORDER BY
   DATE_FORMAT(date,'%m %d') < DATE_FORMAT(NOW(),"%m %d"),
   DATE_FORMAT(date,'%m %d');

```

First, order by whether or not the date is less than the current date, then order by month and date in ascending order.

**NOTE**
This looks like the method Col. Shrapnel was referring to.
something like order by if(date\_format(date,'%m%d') < date\_format(now(),'%m%d')),1,0), date\_format(date,'%m%d')