COmentari eliminat correctament ";
header("Location: noticia.php");
}
?>
AdminWeb
Noticia
$row[titol] ";
// MOSTRAR NOM CATEGORIA ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
$idCate=$row[categoria];
$result_categoria=@mysql_query("SELECT * FROM categories WHERE ID_categoria=$idCate",$link);
while($rowCate = @mysql_fetch_array($result_categoria)) {
echo "Categoria: $rowCate[nom_categoria] ";
}
@mysql_free_result($result_categoria);
// FI MOSTRAR NOM CATEGORIA +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
echo "Data: $row[data] ";
echo "$row[text] ";
// MOSTRAR COMENTARIS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
$result2=@mysql_query("SELECT * FROM comentaris WHERE idnoticia=$id ORDER by data",$link);
$numregistres=mysql_num_rows($result2);
if ($numregistres){
echo "COMENTARIS ";
while($rowCom = @mysql_fetch_array($result2)) {
echo "$rowCom[nom_comentari] ";
echo "$rowCom[titol_comentari] ";
echo "$rowCom[text_comentari] ";
echo "$rowCom[data] ";
echo " ";
}
}
else {
echo " No hi ha comentaris";
} // FI MOSTRAR COMENTARIS ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
} // FI MOSTRAR NOTICIES
@mysql_free_result($result);
@mysql_free_result($result2);
?>
<- TORNAR ->