Hi,
I'm out of cash so am going this one alone! :) What I want to do is add a basic expire time/function to the links when added. If it looks like I'm heading in the wrong direction with this one I'd appreciate the comments.
All of the links in my directory are added by the administrator, through the admin area. So, this was how I thought it would work to exclude all links that are over 1 year old from the build and have Expire set to Yes (those with Expire set to No don't expire).
1. Add a new field to Links - Expire Yes|No
2. Add a new timestamp field to Links
3. Every link added gets a timestamp of now()
4. When building the directory, the build includes only those links with an expire time > (now() - 1 year) and Expire = Yes, and all those with Expire = No. (is this possible in the same query?)
Does that look like I'm doing it the right way, or is there an easier solution anyone can think of?
Cheers,
Regan.
I'm out of cash so am going this one alone! :) What I want to do is add a basic expire time/function to the links when added. If it looks like I'm heading in the wrong direction with this one I'd appreciate the comments.
All of the links in my directory are added by the administrator, through the admin area. So, this was how I thought it would work to exclude all links that are over 1 year old from the build and have Expire set to Yes (those with Expire set to No don't expire).
1. Add a new field to Links - Expire Yes|No
2. Add a new timestamp field to Links
3. Every link added gets a timestamp of now()
4. When building the directory, the build includes only those links with an expire time > (now() - 1 year) and Expire = Yes, and all those with Expire = No. (is this possible in the same query?)
Does that look like I'm doing it the right way, or is there an easier solution anyone can think of?
Cheers,
Regan.