% 'counter = 0 sql = "SELECT * FROM testimonials WHERE active = 1 ORDER BY id" rs.Open sql , Conn 'counter = rs.recordcount if not rs.eof then sdetails = rs("details") iID = rs("id") dtLastDate = rs("last_updated_on") else sdetails = "" iID = 0 dtLastDate = now() end if rs.close %>
|