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.yaketyyakallmouth.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
Expand|Select|Wrap|Line Numbers
- <% 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 %>