I got this form with 3 options: 1-comedy, 2-action, 3-sf.
I want to select from database the title and dvd nr based on the catagory field (see the 3 options).
How do I do that?
Pls help me

<%
'database field value
newval=rs("option")
if newval="comedy" then
sel1="checked"
elseif newval="action" then
sel2="checked"
elseif newval="sf" then
sel3="checked"
end if
<%
<input type="checkbox" <%=sel1%> name="comedy">
<input type="checkbox" <%=sel2%> name="action">
<input type="checkbox" <%=sel3%> name="sf">

surendran
(Anything is Possible)

Hi,
 If it is a single selection you can use radio button as follows..

<input type="radio" name="category" value=1>comedy
<input type="checkbox" name="category" value=2>action
<input type="checkbox" name="category" value=3>sf

After submitting the page then get the value as follows..

Dim selectedvalue
selectedvalue = Request.form("category")
after this use the following query..

strSql= "select * from category_table where category_id=" & selectedvalue


Thanks
Suresh