[SOLVED] query results where date = NOW() -> 30 days

[Mr_jmm]

I ahve a table of website domains that also stores their renewal date. I am trying to write a query that will return a list of domains that are due to expire in the next 30 days.

 

So far I have:

<?php $query = mysql_query("SELECT website_domain, renewal_date FROM websites WHERE renewal_date = NOW(), +30 days"); ?>

 

but this shows a sytax error. Could anyone help with this please?

 

Many thanks as always,

 

James

[Mr_jmm]

Sorry, I think my starting place should be:

 

<?php $query = mysql_query("SELECT website_domain, renewal_date FROM websites WHERE renewal_date BETWEEN NOW(), 30 days"); ?>

[Mr_jmm]

SOLVED!

 

<?php $renewal_query = mysql_query('SELECT website_title, website_domain, renewal_date FROM websites WHERE renewal_date > NOW() AND renewal_date < adddate(NOW(), INTERVAL 30 DAY)');
?>