list only some stuff in a db

[help120]

I want to show info based on what's in a field. This is what I was thinking of..

if request.field("category&quot = photoshop then

response .write rs("title&quot

end if

 

[SrinuReddy]

If u are compring and then displaying then use :

if strcomp(request.field("category&quot& "","photoshop",vbtextcompare)= 0 then

response.write rs("title&quot

end if

 

[SrinuReddy]

If u are compring and then displaying then use :

if strcomp(request.field("category&quot& "","photoshop",vbtextcompare)= 0 then

response.write rs("title&quot

end if

srinu...