%
set convideo = Server.CreateObject("ADODB.Connection")
convideo.open con_string
Strcategory="select * from Gallery_Category order by vieworder asc"
Set rsCategory = Server.CreateObject("ADODB.Recordset")
rsCategory.open Strcategory,convideo
%>
<%=pagename%>
<%
vd_ctr=1
do while not rsCategory.eof
Stritems="SELECT videogallery.*, videogallery.Category FROM videogallery WHERE (((videogallery.Category)="&rsCategory("id")&")) order by vieworder asc;"
Set rsitems = Server.CreateObject("ADODB.Recordset")
rsitems.open Stritems,convideo
ctritem=1
do while not rsitems.eof
%>
<%if ctritem=1 then%>
| <%=rsCategory("Category_Name")%> |
<%end if%>
<%if ctritem=1 then%>
<%end if%>
|
|
<%if ctritem=2 then
ctritem=0
%>
<%end if
ctritem=ctritem+1
%>
<%rsitems.movenext
loop
%>
<%
If ctritem mod 2 = 0 Then
%>
|
<%end if%>
<%rsCategory.movenext
loop
%>
<%=Click_the_image_to_view_the_video%>