Trying To Display The Number Of Active Users Using A MYSQL Statement
 

I'm trying to display a table called (vb_users) where the 'lastactivity' is less than 365 days. I can't seem to get the query right? Any suggestions? This is what I have. I cant get it to count certain rows but nothing else. I want it to display their email and other attributes in the results.


Code:
SELECT
count*
FROM `vb_user`
where lastactivity > (31557600)