Days in Database

[Anon]

Ok, this is kinda hard to explain, but I will try.

I'm entering inventory into my mysql database, I'm trying to make it so that after something is still in the inventory for 10 days it changes status. Or even a date compare would work, like if the date it was entered into the database is 10 days older then todays date, then the status changes.

I just can't figure out a way to do it. Anyone have any ideas?

Thanks
Shadowhunter

[Anon]

http://www.mysql.com/doc/D/a/Date_calculations.html

[Anon]

Thanks a bunch for the link. It explained very well how to do the MySQL end of it, I guess I should have pointed out that I'm not extremely knowledgable with PHP though, so I'm still a bit lost =).

Shadowhunter