--or:
select count(*) from article where Arttime>=dateadd(mm,-1,getdate())
[/Quote]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) from article where Arttime>=dateadd(mm,-1,getdate())' at line 1