| |
<% /*Paginado*/
$disprows=10;//ver si sale de un parametro general
if (!isset($go) || trim($go)=="")
{
$go=0;
}
$curr=$go;
$prev=$go - $disprows;
$next=$go + $disprows;
$sql = "select t.*,f.* from forTema t,forForo f
where t.forID=f.forID
order by f.forNombre,t.temFecha desc
limit $curr,$disprows"; $rs = $conn->execute($sql);
if (!isset($max) || trim($max)=="")
{
$sqlaux = "select count(*) as CANT from forTema t,forForo f
where t.forID=f.forID";
$rsaux = $conn->execute($sqlaux);
$max=$rsaux->field(CANT);
}
$numpage=ceil($max/$disprows);
if(!isset($currpage) || trim($currpage)=="")
{
$currpage=1;
}
%>
|
|
<%=$I_title%> |
<%=$I_author%> | <%=$I_date%> |
<%=$I_forum%> |
<%
$color="#eeefff"; $image="icon_editar.gif";
while(!$rs->eof)
{ $temID = $rs->field("temID");
$forNombre = $rs->field("forNombre"); $temTitulo = $rs->field("temTitulo");
$temAutor = $rs->field("temAutor");
$temFecha = verFecha($rs->field("temFecha"),"/",0);
%>
>
|
|
<%=checkVar($temTitulo);%>
|
"><%=checkVar($temAutor);%>
|
<%=checkVar($temFecha);%>
|
<%=checkVar($forNombre);%>
|
<%
if($color=="#eeefff"){$color="#dcdcee";$image="icon_editar2.gif";} else if($color=="#dcdcee"){$color="#eeefff";$image="icon_editar.gif";}
$rs->movenext(); } %>
<%=$I_page%> <%=$currpage%> <%=$I_of%> <%=$numpage%> (Total <%=$max%>)<%if($ayudaID!=0){echo " ![\"Help\"](\"images/icon_ayuda.gif\") ";}%> |
|  |
|
<%if($prev>=0){%> <%}else{%> <%}%> | <%if($currpage<$numpage){%> <%}else{%> <%}%> |
|
|
