Ok -- pulling current date from date(); and pulling last date from mysql database and converting both to Month (F) format.

Code to find current month:
$current_month = date(F);
echo $current_month;

Code to find last month listed:
$q_maxdate = mysql_query("SELECT MAX(start_date) from courses.courseschedule;");
$q_maxdate_result = mysql_fetch_row($q_maxdate);
$q_maxdate_result = $q_maxdate_result[0];
$date = new DateTime($q_maxdate_result);
$format_late_date = $date->format("F");
echo $format_late_date;

Would like to be able to find the months between those two dates and then post them.

Anyone know how? Can't really +1 to a date????

Thanks

Not sure about your DB dates functions, but look at them, rather than doing this in PHP.
It's way more easy...
If you are using mysql5, what you want to look upon is the dateAdd():
http://dev.mysql.com/doc/refman/5.0/...nction_adddate

mysql> SELECT DATE_ADD('1998-01-02', INTERVAL 31 DAY);
        -> '1998-02-02'

Similar functions exists in almost every databases, and are more flexible than parsing the pure date value in PHP.

You can also try this to get dates within the last X days, so if you wanted dates within the last 30 days try

PHP Code:


SELECT * FROM db_name WHERE TO_DAYS( NOW(  'y-m-d'  )  )  - TO_DAYS( date )  >= 30