1.<!--#include file="connection.asp"-->
2.<%
3.openConn()
4.email = request("email")
5.response.Write(email)
6.''response.End()
7.if trim(email) <> "" then
8.
9.sql= "select password from candidate where email = '" & replace(email,"'","''") & "'"
10.''response.Write(sql)
11.''response.End()
12.set rs = createobject("adodb.recordset")
13.rs.open sql,conn
14.''response.End()
15.if not rs.eof then
16.set msg = createobject("CDO.Message")
17.msg.to = email
18.''response.Write(email)
19.msg.from = "tranlinh.nmt@gmail.com"
20.msg.subject = "123456"
21.' pass for mail:tranlinh.nmt@gmail.com
22.msg.TextBody = "Hello. Your password is " & rs("password")
23.response.Write rs("password")
24.''response.End()
25.msg.Send
26.response.End()
27.end if
28.rs.close
29.end if
30.%>
star sports online 
Marked 
