include('include/funzioni.php'); $MAX_MESS = 5; function trovaCommenti($IDblog) { $strSQL = "SELECT IFNULL(COUNT(IDriga),0) FROM blogcommenti WHERE IDblog=$IDblog"; //echo $strSQL; $rstTemp = @mysql_query($strSQL); $rst = @mysql_fetch_array($rstTemp); $numCommenti = $rst[0]; if ($numCommenti>0) { return "commenti ($numCommenti)"; } else { return "commenta"; } } include('Connections/conn.php'); if ($pag=="") { $pag = 0; } else { if ((int)($pag<0)) { $pag = 0; } } $strSQL = "SELECT umori.path, umori.descrizione, blog.* FROM blog INNER JOIN umori ON blog.IDumore=umori.IDumore ORDER BY istante DESC LIMIT $pag,$MAX_MESS "; if ($mese!="") { $strSQL = "SELECT umori.path, umori.descrizione, blog.* FROM blog INNER JOIN umori ON blog.IDumore=umori.IDumore WHERE istante >= '$mese-01' AND istante < DATE_ADD( '$mese-01', INTERVAL 1 MONTH ) ORDER BY istante DESC LIMIT $pag,$MAX_MESS "; } if ($idBlog!="") { $strSQL = "SELECT umori.path, umori.descrizione, blog.* FROM blog INNER JOIN umori ON blog.IDumore=umori.IDumore WHERE IDblog=$idBlog ORDER BY istante DESC LIMIT $pag,$MAX_MESS "; } //echo ""; $rstTesto = @mysql_query($strSQL); //mysql_close(); ?>

| echo formattaTesto($rowTesto["titolo"]); ?> | echo formattaIstante($rowTesto["istante"]); ?> |
| ::::....^
if ($rowTesto["musica"]!="") {?>
',WIDTH,150);" onMouseOut="return nd();"> |
|
| echo formattaTesto($rowTesto["testo"]); ?> | |
| echo trovaCommenti($rowTesto["IDblog"]); ?> | |
|
if ($pag!=0) {
echo " << successivi";
}
?> |
if ($num_mess==$MAX_MESS) {
?>
echo "precedenti >>";
}?> |
| ^archivio^ |
| ^icone^ | |
![]() ... |
umore del momento |
![]() |
colonna sonora |