Display by month
Could you supply your complete getRecords call? I suspect your where clause is the issue.
Sorry for the delay. Every I still Google these things as it's faster. Here's my process:
- Google: mysql get date for start of month - https://www.google.ca/search?q=mysql+get+date+for+start+of+month
- Scan some stackoverflow posts for some easy code: DATE_FORMAT(NOW() ,'%Y-%m-01')
- Try it out in MySQL Console: https://www.interactivetools.com/add-ons/developer-console/
- Come up with where query: domain_registered >= DATE_FORMAT(NOW() ,'%Y-%m-01')
'where' => " domain_registered >= DATE_FORMAT(NOW() ,'%Y-%m-01') ",
Hope that helps!