If request.form("gtype") = "title" then
sql = "select * from tablename where title like '%" & request.form("keyword") & "%' order by title"
elseif request.form("gtype") = "author" then
sql = "select * from tablename where author like '%" & request.form("keyword") & "%' order by author"
elseif request.form("gtype") = "subject" then
sql = "select * from tablename where subject like '%" & request.form("keyword") & "%' order by subject"
end if
Load balance : Server 05
