SELECT count(*)
  FORM   table1
  WHERE  day='$d'
    AND  month='$m_num'
    AND  year='$y'