Today's Date Plus 30 days

[TecTao]

I'm trying to create a variable for today's date plus 30 days. to use in a sql WHERE statement.

 

I've established today's date as

 

$today = date("Y-m-d");

 

The SQL statement says WHERE _date >= '$today'

 

But I want it to select items up to 30 days from todays date.

 

Any suggestions?

 

Thanks,

Mike

[corbin]

The easiest way to do it would be to do it natively in MySQL with a date column (or datetime).

 

 

The field isn't a varchar is it?  If so, >= won't work.

 

 

Anyway to answer your question directly:

 

date("Y-m-d", 30*86400 + time());

 

 

If the column is DATE or DATETIME:

 

WHERE col >= DATE_ADD(CURDATE(), INTERVAL 30 DAY)

[dadamssg]

another way...

 

$thirtydays = gmmktime(0,0,0,date('n'),date('j')+30,date('Y'));

 

then put $thirtydays in your query