codice:
<?
include "../include/db.php";
include "../include/pag.php";
include "../include/date-time_function.inc.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Cerca nel Forum</title>
<link rel="stylesheet" type="text/css" href="../stile.css" media="screen" />
</head>
<body>
<? include "menu.php";
echo "
";
?>
<table width="100%" padding="1" bgcolor="#FFFFFF"><tr><td>
<?
$Parola = $_POST["Parola"];
$query = "SELECT * FROM Forum_Discussioni WHERE Titolo LIKE '%$Parola%' ORDER BY Ultimo DESC";
$result = mysql_query($query, $db);
$argomenti = mysql_num_rows($result);
if ($argomenti==0) {
echo "<center>Non sono stati trovati risultati

<a href=javascript:history.back()>Indietro</a></center>";
} else {
while ($row = mysql_fetch_array($result)) {
$discussione1 = $row["ID"];
$click1 = $row["Click"];
$tit1 = $row["Titolo"];
$tit1 = htmlspecialchars($tit1);
$query2 = "SELECT * FROM Forum_Messaggi WHERE Discussione = $discussione1 ORDER BY ID DESC";
$result2 = mysql_query($query2, $db);
$row2 = mysql_fetch_array($result2);
$messaggi1 = mysql_num_rows($result2);
$ultimo1 = $row2["Utente"];
$data_dal_db1 = $row2["Data"];
$anno_db1 = getYear($data_dal_db1);
$mese_db1 = getMonth($data_dal_db1);
$giorno_db1 = getDay($data_dal_db1);
$ora_db1 = getHour($data_dal_db1);
$minuti_db1 = getMinutes($data_dal_db1);
$secondi_db1 = getSeconds($data_dal_db1);
$inserito1 = $giorno_db1."-".$mese_db1."-".$anno_db1." ".$ora_db1.":".$minuti_db1.":".$secondi_db1;
$query3 = "SELECT * FROM Forum_Messaggi WHERE Discussione = $discussione1 ORDER BY ID";
$result3 = mysql_query($query3, $db);
$row3 = mysql_fetch_array($result3);
$primo1 = $row3["Utente"];
$query4 = "SELECT * FROM Forum_Messaggi WHERE Discussione = $discussione1 AND Risposta = '1' ORDER BY ID DESC";
$result4 = mysql_query($query4, $db);
$risposte1 = mysql_num_rows($result4);
echo "<div style=\"background-color: #FFF; height: 70px; width: 33%; border: 1px solid #000; float: left; margin: 0;\"><a href=\"messaggio.php?ID=".$row["ID"]."\">$tit1</a>";
echo "</div><div style=\"background-color: #FFF; height: 70px; width: 18%; border: 1px solid #000; float: left; margin: 0;\" align=\"center\">Iniziato da:
<a href=\"../utenti/index.php?Utente=$primo1\">$primo1</a></div><div style=\"background-color: #FFF; height: 70px; width: 13%; border: 1px solid #000; float: left; margin: 0;\" align=\"center\">Risposte:
$risposte1</div><div style=\"background-color: #FFF; height: 70px; width: 19%; border: 1px solid #000; float: left; margin: 0;\" align=\"center\">Ultimo messaggio:
$inserito1 di
<a href=..\utenti/index.php?Utente=$ultimo1\" target=\"_blank\">$ultimo1</a></div><div style=\"background-color: #FFF; height: 70px; width: 13%; border: 1px solid #000; float: left; margin: 0;\" align=\"center\">Visite:
$click1</div>";
}
}
?>
</td></tr></table>
</div>



<form action="argomento.php" method="post" name="argomento">
Vai ad un altro forum:

<select name="Argomento">
<?
$query = "SELECT * FROM Forum_Argomenti ORDER BY ID";
$result = mysql_query($query, $db);
while ($row = mysql_fetch_array($result)) {
$argomento = $row["ID"];
echo "<option value=\"\">--> ".$row["Titolo"]."</option>";
$query2 = "SELECT * FROM Forum_Sottoargomenti WHERE Argomento = $argomento ORDER BY ID";
$result2 = mysql_query($query2, $db);
while ($row2 = mysql_fetch_array($result2)) {
if ($sottoargomento==$row2["ID"]) {
$selected = "selected";
} else {
$selected = "";
}
echo "<option value=\"".$row2["ID"]."\" $selected>".$row2["Titolo"]."</option>";
}
}
?>
</select>
<input name="Invia" type="submit" value="Vai" />
</form>
</body>
</html>
$query = "SELECT * FROM Forum_Discussioni WHERE Titolo LIKE '%$Parola%' ORDER BY Ultimo DESC";
questa ricerca devo farla anche su
$query = "SELECT * FROM Forum_Messaggi WHERE Titolo LIKE '%$Parola%' ORDER BY Ultimo DESC";
ma integrandole, come fare?