MYSQL/PHP Query question

I was wondering if anyone on here could help.....

I've been given the task of creating an index for our website at work based on some data in a database...

Basically, it's product release date data, the thing is the data is in the following format:

2007-11-01 00:00:00

Some of the release dates are 2020-11-01 00:00:00 but this is too far in the future, what i need to do is have the query return stuff released in the next 30 days.

The table is called P_products and the column with the release dates is called release_date. I know it's cheeky but would somebody please be able to help me out with an example?

I'm using PHP so i guess i'll need to set a variable with the current date in it?

Thanks

give this a go:

$today = date('Y-m-d', strtotime('now'));
$oneMonthAway = date('Y-m-d', strtotime('+1 month'));


$query = "SELECT * FROM posts WHERE release_date BETWEEN '$today' AND '$oneMonthAway' ORDER BY release_date DESC"

do you see what's happening? if not, post again