%if request("do")= "del" Then
SQLDel = "UPDATE Forces_BoardingSchools SET Deleted = 'yes' WHERE SchoolID = "&request("id")&" "
Set RSDel = MyConn.Execute(SQLDel)
response.redirect "admin-boarding-schools.asp"
end if
%>
<%
SQLAccountsR = "SELECT * FROM Forces_BoardingSchools WHERE Deleted = 'no' ORDER BY SchoolID DESC"
Set RSAccountsR= MyConn.Execute(SQLAccountsR)
if RSAccountsR.EOF then
response.write("
There are currently no schools.
")
else
i = 0
while not RSAccountsR.EOF
%>
<%i= i + 1%>
<%if int(i)/2 = int(i)\2 then%>
<%else%>
<%end if%>
<%=RSAccountsR("SchoolName")%>
<%GetLocations = "SELECT * FROM Forces_LocationAreas WHERE AreaID = '"&RSAccountsR("Location")&"' "
SET RSLocations = MyConn.execute(GetLocations)
Do While NOT RSLocations.EOF%>
<%=RSLocations("Area")%>
<%RSLocations.Movenext
Loop%>