CODE EXAMPLE FOR SQL

php mysql select current month

mysql> select count(*) from users
       where MONTH(date_joined)=MONTH(now())
       and YEAR(date_joined)=YEAR(now());