need help selecting info based on date

[drumhrd]

 

I need a way query a DB and get results based on the DATE in the table.  where the <current date> is greater than  2 DAYs away from the DATE in the table.

 

so I have a table

 

DATES

--------

2009-4-2

2009-4-3

2009-4-4

2009-4-5

2009-4-6

 

$current_date = 2009-4-2

 

SELECT * FROM <TABLE> WHERE DATE > 2 days from $current_date;

 

I want to query the DB and should get 2009-4-4, 2009-4-5, and 2009-4-6

 

 

 

 

[drumhrd]

well..I did some googling.

 

found my answer

 

SELECT *

FROM table

WHERE datefield > DATE_ADD( CURDATE( ) , INTERVAL +2

DAY )