Topic: 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 )