|
Categorias
|
Total
de Relatos
|
<%
on error resume next
sql = "SELECT C.nome,R.Categoria, COUNT(R.Categoria) As total FROM textos AS R, categoria AS C WHERE R.categoria=C.id_cat and R.liberado = true GROUP BY C.nome,R.Categoria ORDER BY Count(R.Categoria) DESC"
call abre_conexao
set rs = objconexao.execute(sql)
t =0
do while not rs.eof
%>
|
&nome=<%=rs("nome")%>"><%=rs("nome")%>
|
<%=rs("total")%>
|
<%
t = t + rs("total")
rs.movenext
%>
|
&nome=<%=rs("nome")%>"><%=rs("Nome")%>
|
<%=rs("total")%>
|
<%
t = t + rs("total")
rs.movenext
loop
set rs = nothing
call fecha_conexao
%>
| |
<%=t%>
|
|
