<% if request.querystring("region") <> "" Then %> Back to Map

Choose a location: <% dbconnect(1) sql = "select distinct(sitelocation) from ukpsf_sites A join ukpsf_sitetoregion B on B.siteid = A.siteid where B.region='" & request.querystring("region") & "' and accredited = 1 order by sitelocation;" set rs=db.execute(sql) if not rs.eof then do while not rs.eof %> "><%= rs("sitelocation") %> <% rs.movenext loop else response.write "No locations available" end if %> #'+ document.all.siteloc.value;">

<% sql = "select * from ukpsf_sites A join ukpsf_sitetoregion B on B.siteid = A.siteid where B.region='" & request.querystring("region") & "' and accredited = 1 order by sitelocation;" set rs=db.execute(sql) if not rs.eof then response.write "" do while not rs.eof %> <% if rs("siteemail") <> "" then %> <% end if %> <% rs.movenext loop response.write "

<%= rs("sitename") %> ("><%= rs("sitelocation") %>) <% if rs("siteurl") <> "" Then %>   " target="_blank"> <% end if %>   #top">Top

<% if rs("accredited") = 1 Then %> <% end if %> <% if rs("sitetext") <> "" then %> <%= rs("sitetext") %> <% end if %>

Contact: <%= rs("sitecontact") %> on <%=rs("sitephone") %>

Email: "><%= rs("siteemail") %>

" else response.write "There are no accredited sites for this region!" end if dbconnect(0) else %>

Featured site: National Paintball Games - Sidcup

<% end if %>