Actually Phorce, in the code you gave him, your sql query only selects those from the database that are active. I believe he wants everything selected from the database and those that are active to be displayed with a link, and those that are inactive to display without a link.
The piece of code that has not been included in his example is the variable from the database that specifies weither it's "Collaborated Poetry" or "Collaborated Screenplay."
One value can not specify link text and an active link. That is why every link keeps being active, because there is always a value. Unless you say that secID=0 is for an inactive link. But if that's the case, what text is displayed?
If that code I gave you isn't working, then you've either done something wrong, or you just haven't explained what it is you want correctly. I'm willing to help you, but I'm going to need more information on what it is you want. Maybe you can send me some of your code or examples, and some of your database stuff so I can further assist you. I also have TeamViewer which would allow us to share your monitor and solve it together.