title: Php mysql select month and year
body: <p>In my MySQL database there is a column which is employment_date in "Y/m/d" format, What I want is, select only year and month of employment_date. Following is the my DB query.</p>
  
  <pre><code>function checkDate($userID){
  $res=mysql_query("Select YEAR (employment_date) AND MONTH(employment_date) from employee where emp_id='$userID'") or die("query error".mysql_error());
  $array = mysql_fetch_array($res);
  $value=$array['employment_date'];
  
  echo("$value");
  }
  </code></pre>
  
  <hr>
  
  <p>But Its not work, what is correct way to select month and year in my table, Please Help !</p>