Selecting the next upcoming events

[cronsrcs]

I have a db table that stores "events". What i want to do is display the next 3 upcoming events, with the event which is next to occur to be the first in the list.

Here is the sql I have at present:

SELECT art_id, art_title, art_date
FROM Article
WHERE art_type =1 AND archived = 0 AND art_date >= "the current date"
ORDER BY art_date DESC limit 3

I am not sure that this is going to give me exactly what I want.

Any ideas?

[r937]

select *
  from (
       select art_id, art_title, art_date
         from Article
        where art_type = 1 
          and archived = 0 
          and art_date >= current_date
       order 
           by art_date desc limit 3
       ) as dt
order
    by art_date asc

use the current_date keyword, luke