OK so i want to make a loop that counts how many entry's there are in my database between two dates (within a month) i have a field called timestamp (which automatically marks when you create a new entry) which is saving d-m-y hh:mm:ss but i only really need the d-m-y part of it. so that one thing i need help with.
So i need to know how to write a loop statement that will only read the entery from this current month
\
$offset = strtotime("-1 month");
$betweenMonth1 = date("d-m-y", $offset);
$betweenMonth2 = date("d-m-y");
Ive got this which will be my two BETWEEN variables i just dont know how to write the code.
Inside will be a count variable, so everytime that loop runs the count will increase and the final number will be the amount of entery for the month.
I am coding this with php and a mysql database.
PLEASE HELP ME WITH CODE!