请教ASP查询语法错误

请教：语法错误 (操作符丢失) 在查询表达式 '* form admin where admin_name=''' 中
我弄了个ASP后台管理登录程序，代码如下：

<!--#include file="conn.asp"-->
<%
dim admin_name,admin_pwd
admin_name=trim(request("admin_name"))
admin_pwd=trim(request("admin_pwd"))
set rs=server.createobject("adodb.recordset")
sql="select * form admin where admin_name='"&admin_name&"'"
rs.open sql,conn,1,1
if not rs.eof then
if admin_pwd=rs("admin_pwd") then
session("admin")=admin_name
session("loginpwd")=admin_name
session("loginname")=admin_pwd
response.redirect "admin_main.asp"
else
response.write"<script languaue='javascript'>window.confirm('密码不正确，请重新登录！！');</script>"
response.write"<script language=&#

<%
dim admin_name,admin_pwd,sql
admin_name=trim(request("admin_name"))
admin_pwd=trim(request("admin_pwd"))
set rs=server.createobject("adodb.recordset")
sql="select * form admin where admin_name=" & admin_name

rs.open sql,conn,1,1
if not rs.eof then
if admin_pwd=rs("admin_pwd") then
session("admin")=admin_name
session("loginpwd")=admin_name
session("loginname")=admin_pwd
response.redirect "admin_main.asp"
else
response.write"<script languaue='javascript'>window.confirm('密码不正确，请重新登录！！');</script>"
response.write"<script language='javascript'>parent.window.history.go(-1);</script>"
end if
else
response.write"<script language='javascript'>window.confirm('用户名不正确！！');</script>"