<% al=requestquerystring("tl") a2=requestquerystring("t2") setcon=server.createobject("adodb.connection") con.open "dsn=reg3" setrs=server.createobject("adodb.recordset") rs.cursortype=adopenstatic if(a1<>"" and a2<>"") then sql="select * from Tabci where zone='"&a1&"' and course="'&a2&"' and status='yes'" elseif(a1 <>"" and a2="") then sql="select * from Tabci where zone='"&a1&"' and status='yes'" elseif(a2<>"" and a1="") then sql="select * from Tabci where course='"&a2&"' and status='yes'" else sql="select * from Tabci where status='yes"' end if rs.open sql,con %>

LEADING COMPUTER EDUCATION CENTRES

Search for a
Computer Intitute:

Location

Course

Control Panel

<% if not rs.eof then dim c,r,i c=Trim(Request("currentpage") ) ifc="" then c=l rs.pagesize=5 rs.absolutepage=cint(c) r=0 j=0 %> <%while not rs.eof and r <% if j mod 2<>0 then cl="white" else cl="lightgrey" end if %> . <% r=r+ 1 j=j+1 rs.movenext wend%>

Institute Name	Address	Phone	Email	Location	Course	Secialization
<%=rs("institute Name")%>	<%=rs("address")%>	<%=rs("phone")%>	"><%=rs("email")%>	<%=rs("zone")%>	<%=rs ("course")%>	<%=rs("specialization")%>

Page <%=c%> of <%=rs.pagecount%> <% for i=1 to rs.pagecount%> <%=i%> <%next %> <%else%>

Name Of Centre	Address	phone	email	Zone	Subject	Class

sorry! your request are not match with data

<% end if %>