%
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
%>
| |
|
|
A
COMPLETE RANGE OF ANTENNA AND SET-TOP BOXES SUITABLE FOR DTH SYSTEMS
OF TODAY AND TOMORROW |
 |
| |
|
|
|
|
|
| |
| :: All India Dealer / Distributor Locater
:: |
| |
|
|
|
|
<% city=request("city")
if city <> "" then %>
|
Name |
Address |
Contact person
& Phone number |
E-mail |
<%
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
%>
| <%=trim(rs2("name"))%> |
<%=trim(rs2("address"))%> |
| <%=trim(rs2("cont_cpn"))%> |
| P : |
<%=trim(rs2("phone"))%> |
| M: |
<%=trim(rs2("mobile"))%> |
|
<%=trim(rs2("email"))%> |
<% rs2.movenext
Wend %>
|
<% end if %>
|
|
| |