I have a table with the following information:
CREATE TABLE information (
ID smallint(6) NOT NULL auto_increment,
PRIMARY KEY (ID),
KEY information_ID (ID)
What I need to do is create a query that will return all records that fall within the range of today plus 30 days and minus 30 days.
If that isnt possible how would i structure just the "today plus 30"? any help is appreciated. Thx