I need result which shows all the dates which expire after or within 90 days form now on(current date) but this query also shows results which already expire like it shows 27 sep 2009 which is before current date. I need only those which are expiring from today and with in 3 months means in October, November, and December.
and when November comes i need alerts for all which are expiring in Nov,Dec, and Jan.
$r=mysql_query("SELECT * FROM lease_south WHERE current_date() >= (LAPeriodEnd - INTERVAL 90 DAY) ");
Thanks in Advance........