<% set con=server.createobject("ADODB.connection") set rs=server.createobject("ADODB.recordset") con.open mm mysql="select distinct state from apna order by state" 'mysql="dist" rs.open mysql,con %> World's best technology for DTH terminals from MCBS <% city=request("city") if city <> "" then %> <% end if %>
A COMPLETE RANGE OF ANTENNA AND SET-TOP BOXES SUITABLE FOR DTH SYSTEMS OF TODAY AND TOMORROW
     
 
:: All India Dealer / Distributor Locater ::
 
 
State :
  <% city=request("city") if state <> "" or city <> "" then set rs1=server.createobject("ADODB.recordset")%> City : <%end if%>  
<% set rs2=server.createobject("ADODB.recordset") mysql2="select distinct name,address,cont_cpn,phone,mobile,email from apna where city='"&city&"' and show='Y' order by name" rs2.open mysql2,con while not rs2.eof %> <% rs2.movenext Wend %>
Name
Address
Contact person
& Phone number
E-mail
<%=trim(rs2("name"))%> <%=trim(rs2("address"))%>
<%=trim(rs2("cont_cpn"))%>
P : <%=trim(rs2("phone"))%>
M: <%=trim(rs2("mobile"))%>
<%=trim(rs2("email"))%>
Home || APNA DTH || Project Overview || Dealer / Distributor || Products || Contact Us