I am making a site that lists various radio stations and some of them are grouped together in pairs, i.e. Capital FM and Capital Gold.
I can get them all to list ok but i want to list the grouped stations on 1 line in pairs so they are next to each other. i have a field in my access database to group them called alpha.
the page can be seen at www.yaketyyakal lmouth.com/radiousefee/
on this page at the top of the list i want it to have 2 Ten FM and next to it Gold (Thames Valley) on the next line the station 2BR (Burnley) on its own with nothing next to and so on with this list as i have said the stations that are paired have the name of the station in the alpha field of the db so they can be paired together
the asp code for the list is as follows
i hope someone can point me in the right direction
I can get them all to list ok but i want to list the grouped stations on 1 line in pairs so they are next to each other. i have a field in my access database to group them called alpha.
the page can be seen at www.yaketyyakal lmouth.com/radiousefee/
on this page at the top of the list i want it to have 2 Ten FM and next to it Gold (Thames Valley) on the next line the station 2BR (Burnley) on its own with nothing next to and so on with this list as i have said the stations that are paired have the name of the station in the alpha field of the db so they can be paired together
the asp code for the list is as follows
Code:
<% Do Until(localRecordset.EOF) %>
<%
If Not localRecordset.EOF Then
%>
<TABLE width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<%
if InStr(localRecordset("amount"),"heading") > 0 then %>
<TR>
<TD width="65%"><%= localRecordset("station") %></TD>
<TD width="9%"> </TD>
<TD width="8%"> </TD>
<TD width="9%"> </TD>
<TD width="9%"> </TD>
</TR>
<%else%>
<TR>
<TD width="65%"><%= localRecordset("station") %></TD>
<TD width="9%"><INPUT name="num" type="checkbox" id="<%= localRecordset("station") %>" value="<%= localRecordset("amount") %>" onClick="calculate(this.form)"></TD>
<TD width="8%"><SPAN class="fee">£<%= localRecordset("amount") %></SPAN> </TD>
<TD width="9%"><INPUT name="<%= localRecordset("station") %>" type="checkbox" id="<%= localRecordset("station") %>2" value="<%= localRecordset("amount") %>" onClick="calculate(this.form)"></TD>
<TD width="9%"><SPAN class="fee">£<%= localRecordset("amount") %></SPAN></TD>
</TR>
<% end if %>
</TABLE>
<% localRecordset.MoveNext
End If
%>
<% Loop %>