How would I say:
....where timeStampField(month) = currentMonth and timeStampField(year) = currentYear
$getmonth = date("F"); July $getyear = date("Y"); 2008
SELECT * FROM table WHERE field_month = '$getmonth' AND field_year = 'getyear';
the field for both is the same field - a timestamp - should this still work?
yes,
to get the current time stamp use time()
$time_now = time();
Or just use an all-SQL solution:
...WHERE MONTH(time_field) = MONTH(NOW()) AND YEAR(time_field) = YEAR(NOW())
