Well, the title says it all. I would like to combine an Editor's Pick page with the Site of the Week/Day mod, so that the SOTD will only choose items from the Editor's Pick section. Sadly, while I am reasonably proficient in PHP, Perl is somewhat beyond me.

One method that I have thought of is to store the ID number of each Editor's Pick in a separate DB, such as pick.db. Then, have the SOTD pick a random ID number from that, and then pull the appropriate link out of the regular links.db.

I just need some help coding it.

Here's how to build a separate db. It's something that was worked out relating to Random Jumps to Detail pages instead of external URLs:

http://www.gossamer-threads.com/...w=collapsed&sb=5


Here's SOTD:
http://www.gossamer-threads.com/...mp;part=all&vc=1

Actually, it looks very do-able. When I get back tonight, I'll try to get it to work, or maybe tomorrow depending...

DT