<html>
<head>
</head>
<style>
  .tdwbg {color:#859559; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; }>
</style>
<body bgcolor="#e3e8d2" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

  <!--#include file="includes/connect.asp"-->
    <table width="100%" border="1" cellpadding="3" cellspacing="0" bordercolor="#e3e8d2" align="center">
 
<%
 
Set rs1=Server.CreateObject("ADODB.recordset")

Set rs=Server.CreateObject("ADODB.recordset")
		


rs.open "select tbl_user.*,tbl_profiles.*,tbl_preferences.* from tbl_user,tbl_profiles,tbl_preferences where tbl_user.User_ID_PK=tbl_profiles.User_ID_FK  and tbl_preferences.Prefer_ID_PK=tbl_profiles.Educationcategory and tbl_user.User_ID_PK="&request("chatid"),cn,3,1
if rs.eof<>true then
strusername=rs("username")
sex=rs("gender")
age=rs("age")
Location=rs("state")&","&rs("country")
strshortdescr=left(rs("ShortDescription"),15)
end if
if (Cn.execute("select Count(*) from Tbl_UserPhotos where User_ID_FK="&request("chatid")&"")(0)) > 0 then
									strphoto=  Cn.execute("select Photo from Tbl_UserPhotos where User_ID_FK="&request("chatid")&" order by Priority Asc")(0)
									'strApproval1=Cn.execute("select Approval from Tbl_UserPhotos where User_ID_FK="&Rs("User_ID_PK")&" order by Priority Asc")(0)
								end if %>
<div align="center">&nbsp;<span class="tdwbg"><b><%=strusername%></b></span></div>
<br>
<tr><td align="center">

 <%if strphoto <> "" then %>
												      <a href="viewimage.asp?id=<%=request("chatid")%>" target="_blank">	<img src="https://matrimonial.findyourfate.com/propics/<%=strphoto%>"  border="0" width="92" height="91"></a><br>
													 
									 <img src="https://matrimonial.findyourfate.com/images/search_icon1.jpg"  border="0"> &nbsp;			 	<a href="viewimage.asp?id=<%=request("chatid")%>" target="_blank"><b>Enlarge 
												<b></a>
												  <%else%>				
												  <img src="<%=varpath%>https://matrimonial.findyourfate.com/images/photo_NotAvailable.gif" alt="" width="92" height="91"> 
												   <%end if %>
								</center>
<%Response.Write "</td><td valign='middle' class='tdwbg'>"%>
<br><b>Sex </b>: <%=sex%><br>
<b>Age </b> :<%=Age%><br>
<b>Location </b> :<%=Location%><br>
<br>

<div align="right">
<a href="../ViewProfile.asp?pid=<%=request("chatid")%>"  style="color:#859559; font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; text-decoration: underline" target=_blank><b>View Profile</b></a>								
	</div>										
<%
response.write "</td></tr>"

'end if
'rs1.movenext
'loop
Response.Write "</table>"
%>
</body>
</html>
