Rs.movenext help

I have a couple of ASP problems,

1. I have a DB, can display records, which is great, BUT at the start of each record I have a approved Yes/no field, and want to display only the records the have yes, so I triedsomething along the line of:

if x_aprvd = false then rs.movenext else (rest of record)

<table........

I know the above is not code correct (no delimiters and all, it's just off the top of my head), I have an existing end if, rs.movenext, loop command later on to loop through and display the records.

2. I've managed to add comments to another record (1 to many routeen)and what I would like to do is, on clicking to add a comment to a record, to add the record id to to a field on the comments table so I can then display the comments related to that record, I've managed to list the record ID's in a list, but have gone brain dead and can't think past this one...

Thanx in advance

the code line above isn't the exact script, it's just an example for quickness, but goes along those sort of lines, but it maybe completely different...it's just the way I was attempting to do it.... I can get the exact code 2night at home, I don't have it with me at work :(

I don't think that the testing value would have to be in "" as it's either Ture or false and not Text, as the text would be represented as "yes" or "no"

For each link you could have a button called "comment". When they click on the button it go's to a page where they can comment on the link. The url for this page would have a queryString for the linkID.

For example. www.youdomain.co.uk/commentOnLink.asp?linkID=2

Let the users add there posts then enter all the details into your comments table including the linkID. ie rs("linkID") = linkID