$m = 'May';
$y = '2010';
$sql = mysql_query("SELECT MONTH(s_in) AS month, YEAR(s_in) AS year FROM sd_record WHERE MONTH = '$m' AND YEAR = '$y'");
echo mysql_num_rows($sql);
$sql = mysql_query("SELECT MONTHNAME(s_in) AS month,
YEAR(s_in) AS year
FROM sd_record
WHERE MONTHNAME(s_in) = ‘$m’ AND
YEAR(s_in) = ‘$y’ ");
QUESTION -> How do I select only the records for the current month and year? Is there a mysql function to return the current month and year? or I need php to get the current month and year for me before passing the query?