disable/archive data from being searched???
I'm trying to figure out the best way to disable/archive data from being searched.
I will have members making postings and say after 5 days from when it was originally posted I don't want that posting to be able to be searched anymore but would like it to still be available for the original poster to view from there members view in case they would like to renew the posting if it is still available... or they can delete or archive it to be able to use it again in the future.
I'm guessing I would have a table for the current listings that would also have a row for active or expired... With this it would allow the member to see on there personal postings page that they have x number current and x number expired which would also say ACTIVE or EXPIRED next to each posting.
Then have an archive table (which I already have) for the member to archive the listing which would be under a separate link for them to see those postings they had before
This is very important since not all member will keep there postings up to date and I don't want to be going through deleting old postings especially once I have many members.
I am using mysql, cgi, perl and php.
I look forward to your reply.