select * from $table where time > ( select date_sub(curdate(),interval 1 week) ) and time
原创文章，作者：键盘游走者，如若转载，请注明出处：http://www.708034.com/2008/09/mysql-%e7%bb%9f%e8%ae%a1%e4%b8%80%e5%91%a8%e6%95%b0%e6%8d%ae/
select * from $table where time > ( select date_sub(curdate(),interval 1 week) ) and time
原创文章，作者：键盘游走者，如若转载，请注明出处：http://www.708034.com/2008/09/mysql-%e7%bb%9f%e8%ae%a1%e4%b8%80%e5%91%a8%e6%95%b0%e6%8d%ae/
