% sqlstmt = "Select DISTINCT PrayFor, PrayerRequest FROM bookofintentions WHERE Active = 'Yes' and Display = 'Yes' ORDER BY PrayFor" rs.open sqlstmt, conn, 3, 3 total = rs.RecordCount %>
| Pray For | Prayer Request | <%IF RS.EOF THEN%> Currently there are no names. <%Else DIM J DO WHILE NOT RS.EOF j = j +1 IF int(j/2) = J/2 then Response.Write "
| " & rs("PrayFor") & " | " & rs("PrayerRequest") & " |
| " & rs("PrayFor") & " | " & rs("PrayerRequest") & " |