New Icon for this week.

[Anon]

Hi, I am wanting to display a 'new' icon besides listings or mysql results where the entry is within the past week. I have stored the placed date in the databse as 0000-00-00 year month day, and wanting the PHP query to do this. Any helpers?

[Anon]

Not tested, but something similiar to this might work...

select * from table where week(curdate()) - week(yourdatefield) < 1;