sql = "SELECT COUNT(*) FROM Members WHERE (Members.last = '" & last_name & "' AND Members.first = '" & first_name & "' AND Members.password = '" & email & "');"
If CInt(rs.Fields(0)) > 0 Then%>
alert("You have entered an invalid or unrenewed member ID.");
else. . .