sql to get all registered users per month

[Skylight_lady]

Hi guys, how do i get the the total amount of users per month. I am trying to use an sql statement to do this but so far i can't seem to find the info online for the correct statement to use. My code is as follows:

 

SELECT * FROM table1, table2 WHERE table1.userID = table2.ID AND table1.RegisterDate = MONTH (current timestamp)

 

I will also need another sql to give me the total amt of users per year.

[Pikachu2000]

Assuming the date is stored in DATE or DATETIME field, this will do the comparison correctly.

 

 . . . AND MONTH(table1.RegisterDate) = MONTH(CURDATE())

[mikosiko]

total amount of users per month

 

and probably you will need a SUM and a GROUP by clause

[Skylight_lady]

 . . . AND MONTH(table1.RegisterDate) = MONTH(CURDATE())

 

It's a DATETIME field. I forgot to mention that. It's perfect. Works for the year too.

 

How would you get last years users? is it by changing the code like:

 

YEAR(CURDATE() - 1)

[Skylight_lady]

It actually work like this:

 

YEAR(CURDATE()) - 1

 

Cheers guys.