I'd like to know how to get only the data for the month we're in.
For example: I have the date 2017-05-10
and I have the date 2017-11-05
, as I do to get the data only from a date with MySQL. I only want the date data 2017-11-05
, so it returns me all the data that is on that date, how can I do this?
What I have so far:
mysqli_query($sql, "SELECT data, sum(total) FROM pedidos";