I was working on a php project, where i wanted to count the total number of clients for last previous month, starting from 1st to 30th. For example, if the current month is Sep 2012, i wanted to find the count of clients i received for the August 2012.
You need not bang your head converting time with php. You can directly use this sql statement.
select count(*) as total from table_clients WHERE `email` LIKE ‘ex@example.com’
and YEAR(date) = YEAR(CURRENT_DATE – INTERVAL 1 MONTH)
AND MONTH(date) = MONTH(CURRENT_DATE – INTERVAL 1 MONTH)
$rset = mysql_query("select count(*) as total from table_invoices WHERE `email` LIKE 'ex@example.com'
and YEAR(date) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH)
AND MONTH(date) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH)");
Use this simple key queries to your advantage.
