valor;
$r=mysql_db_query($bdd,"select * from opcions where nom='n2'");
$f=mysql_fetch_object($r);
$n2=$f->valor;
//Recupero categories per la taula
$sql="select a.idcat, a.categoria, count(b.idcat) as numero from categoria as a left join directori as b on a.idcat=b.idcat where b.baixa IS NULL group by a.idcat order by a.categoria";
$res=@mysql_query($sql);
if (!$res) {$res1=@mysql_close($idcn);retorna(100);}; //No puc mirar-ho
$cats_taula="";
$cats_desplegable=array();
$cats_desplegable[]="\n";
$comptador=1;
while($fila = mysql_fetch_assoc($res)) {
if (bcmod($comptador,3)==1) {$cats_taula.="
";}
$cats_desplegable[]="\n";
$comptador++;
}
//Recupero 5 últims per la llista 5 últimes entrades
// $n1 indica el nombre de minisites que han d'aparèixer
$sql="select b.seqsite, DATE_FORMAT(b.alta, '%d/%m') as data_alta, b.nom, b.poblacio, c.categoria from minisite as b, categoria as c, clients as a where a.baixa is null and a.suspens is null and autoritza_nom is not null and a.idcli=b.idcli and b.idcat=c.idcat order by b.alta DESC, b.seqsite ASC LIMIT 0,".$n1;
$res=@mysql_query($sql);
if (!$res) {$res1=@mysql_close($idcn);retorna(100);}; //No puc mirar-ho
$ultims_cinc.="
";
// $n2 indica el nombre de fitxes que han d'aparèixer
$sql="select DATE_FORMAT(b.actualitzat, '%d/%m') as data_alta, b.nom, b.poblacio, c.categoria from directori as b, categoria as c where b.baixa is NULL and b.actualitzat is NOT NULL and b.idcat=c.idcat order by b.actualitzat DESC LIMIT 0,".$n2;
$res=@mysql_query($sql);
if (!$res) {$res1=@mysql_close($idcn);retorna(100);}; //No puc mirar-ho
$comptador=1;
while($fila = mysql_fetch_assoc($res)) {
$fila=stripslashes_array($fila);
if (bcmod($comptador,"2")==1)
{
$ultims_cinc.="
![](\"images/pixel10.gif\"){kind=tracking}
![](\"images/punt_lila.gif\")
Minisites![](\"images/arr1.jpg\")
