I just post the form to a new page by doing the following
<form name="form1" method="post" action="newpage.asp">
and then in newpage.asp
// request the form data
//connect to the database, which you said you can do
//build my sql string
thesql="SELECT * FROM mytable WHERE whatiwanttosearch LIKE '%" & searchtext & "%'"
//only do the following if a match has been found
if not rs.eof or not rs.bof then
//write out as to which record has been found
loop until rs.eof
hope this makes sense and that everything works. any more queries don't hesitate to ask.