%
city = request.querystring("city")
name = request.querystring("name")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.mappath("db/admin.mdb"))
set rs = Server.CreateObject("ADODB.Recordset")
set rs1 = Server.CreateObject("ADODB.Recordset")
set rsLayout = Server.CreateObject("ADODB.Recordset")
rs.Open "select * from DistributionPoints where city=" & city & "", conn
rslayout.Open "select * from tblMagazinesDetail", conn
%>
 |
|
|
<%=rsLayout("comment1")%>
|
|
<%=name%> |
<%
do while not rs.eof
%>
| <%=rs("name")%> |
<%=rs("address")%> |
<%=rs("tel")%> |
| Website: |
"><%=rs("website")%> |
|
<%
rs.movenext
loop
%>
|  |
|