title: How to compare current date with mysql date?
body: <p>i am tried to display the current birthday by matching the current date .
  Mysql date format was 16 September 1990, So i  trimmed the year from the current date and echoed 16 Sep, Now how to echo ,if the current date is equal to the date in the row . I tried the below method ,it was an error .</p>
  
  <pre><code>$timezone = new DateTimeZone("Asia/Kolkata" );
  $date = new DateTime();
  $date-&gt;setTimezone($timezone );
  $date2= $date-&gt;format( 'd M' );
  $date4=date('d M', strtotime($date2));
  
  
  &lt;?php $sel = $db-&gt;query("select * from mov_birthday where date('d M', strtotime(dateofb)) == '$date4' order by dateofb"); 
  
  while($row=mysql_fetch_array($sel)){
  
  echo ($row['name']); } ?&gt;
  </code></pre>