php limit results by 30 days
SELECT * FROM all_count WHERE DATEDIFF(date,NOW()) >= -30 and member ='000002'
Source: stackoverflow.com
SELECT * FROM all_count WHERE DATEDIFF(date,NOW()) >= -30 and member ='000002'