<% response.buffer="true" if request.form("Submit")<>"" then if request.form("loginid")<>"" and request.form("password")<>"" and request.form("firstname")<>"" and request.form("lastname")<>"" and request.form("email")<>"" and request.form("citystate")<>"" and request.form("country")<>"" then sqlchk="select loginid from profile where loginid='"& request.form("loginid") &"'" set rschk=conn.execute (sqlchk) if rschk.eof then sqlins="insert into profile (loginid,password,firstname,middlename,lastname,email,website,street,country,profession,company,lebaneseorigin,aboutyou,citystate,birthyear,dateofreg) values('"&replace(request.form("loginid"),"'","''")&"','"& replace(request.form("password"),"'","''")&"','"&replace(request.form("firstname"),"'","''")&"','"&replace(request.form("middlename"),"'","''")&"','"&replace(request.form("lastname"),"'","''")&"','"& replace(request.form("email"),"'","''")&"','"&replace(request.form("web"),"'","''")&"','"&replace(request.form("street"),"'","''")&"','"& replace(request.form("country"),"'","''")&"','"&replace(request.form("profession"),"'","''")&"','"&replace(request.form("company"),"'","''")&"','"&replace(request.form("lebaneseorigin"),"'","''")&"','"&replace(request.form("aboutyou"),"'","''")&"','"& replace(request.form("citystate"),"'","''")&"','" &replace(request.form("birthyear"),"'","''")& "','" & now &"')" response.write sqlins 'response.flush set rsins=conn.execute (sqlins) response.redirect ("search.asp") else messagetext="Loginid is already taken, please choose another one." end if else messagetext="Please fill in all manadatory fields" end if end if %> Register

<%=messagetext%> 
Register your profile here

Loginid *
Password *
First Name *
Middle Name
Last Name *
Country*
Email Address *
Web Address
Street Address
Profession
Company/ Institute
City / State *
Birth Year
Lebanes Origin
About You