what Condition (query) will use when data already exit ?

data in table like this.

userid..empno..vdate....video1...........video2... ........video3........video4....video5
-----------------------------------------------------------------------------
Martin.06367.. 1/2/2005..Office Safety....................Road Safety.....................
Martin.06367. 2/2/2005..------------... Electrical Safety.--------........................
John...01237. 2/2/2005...------.........Electrical Safety.................................
John...01237. 4/2/2005..Office Safety..--.................Road Safety....................
Peter..01541. 5/2/2005...Office Safety..-----..............Road Safety....................
Peter..01541. 6/2/2005....---------.....Eelectrical Safety.--------.......................
and so on

desh means emty records (not view the video)


userid=Request.QueryString("userid")

checkbox1=Request.Form("checkbox1")
checkbox2=Request.Form("checkbox2")
checkbox3=Request.Form("checkbox3")
........
....



Martin view the video1, video2 and video3, and not view the video4 and video5

// before insert the records how can check (condition) that Martin view the video1,video2 and video3,
it give message already view the video if user check checkbox video4 and video5 then it insert the record.


what condition (Query) will use in asp to check the records in the table ?

records insert like this.


isql1="insert into PVideo (video1,video2,video3,video4,video5,video6,video7, video8,video9,video10,video11,video12,video13,vide o14,userid,vdate) values ("
isql3="'" & checkbox1 & "',"
isql4="'" & checkbox2 & "',"
isql5="'" & checkbox3 & "',"
.......
...

isql18="'" & vdate & "')"

regards

Mateen