0

I am trying to count num rows of clients with today's birthday. The problem is, I don't know how I can remove Y from the query (client_dob Format is 1995-12-28) I trying to achieve this using this code:

$stmt = $con->query("SELECT * FROM  clients WHERE DATEDIFF(NOW(),'client_dob')");
  echo(mysqli_num_rows($stmt));
$stmt->close();

Any simple solution?

Dharman
  • 30,962
  • 25
  • 85
  • 135

0 Answers0