I run a unsigned band database and I want to have a search field that specifys when the band was added to the database.
At the moment i have a select box (called time_period) with "Last 10 weeks" and "From the beginning" and at the moment when i get a new band entry i select "Last 10 weeks", and each week i change the old entrys (that are now 11 weeks old) to "From the beginning". Is there anyway i can make the database do this automatically?
I thought of adding a data field, but i'm not sure how that would work.
Any help would be appreciated.
Thanks.
At the moment i have a select box (called time_period) with "Last 10 weeks" and "From the beginning" and at the moment when i get a new band entry i select "Last 10 weeks", and each week i change the old entrys (that are now 11 weeks old) to "From the beginning". Is there anyway i can make the database do this automatically?
I thought of adding a data field, but i'm not sure how that would work.
Any help would be appreciated.
Thanks.