echerche
0;$c--){
if($i!=0) {
if ($type=="and")
$conditions=$conditions."AND";
else
$conditions=$conditions."OR";
}
$conditions=$conditions." text LIKE '%".$tab[$i]."%' ";
$i++;
}
$conditions=$conditions.")";
}
//on recupère le nombre de résultats
if($table!="all"){
$query= "SELECT * FROM ".$table." where ".$conditions." order by pos;";
$result = @mysql_query($query);
$nb= @mysql_numrows($result);
}
else{
$query1= "SELECT * FROM historique where ".$conditions." order by pos;";
$query2= "SELECT * FROM fondements where ".$conditions." order by pos;";
$query3= "SELECT * FROM principes where ".$conditions." order by pos;";
$nb= @mysql_numrows(@mysql_query($query1));
$nb+= @mysql_numrows(@mysql_query($query2));
$nb+= @mysql_numrows(@mysql_query($query3));
}
echo "
";
if($nb==0) echo "Aucun résultat
";
if($nb==1) echo "1 résultat trouvé pour votre recherche :
";
if($nb>1) echo "$nb résultats trouvés pour votre recherche :
";
echo "
";
//affichage des résultats
if($table!="all"){
$result = @mysql_query($query);
while($val = @mysql_fetch_array($result)){
$titre = stripslashes($val["titre"]);
$text = stripslashes($val["text"]);
$typeTitre = $val["typeTitre"];
$pos = $val["pos"];
echo "\n
".nl2br(doHTML($titre))."\n";
echo "".eregi_replace($requete,"".$requete."",nl2br(doHTML($text)))."
\n
";
}
}
else{
$result1 = @mysql_query($query1);
while($val = @mysql_fetch_array($result1)){
$titre = stripslashes($val["titre"]);
$text = stripslashes($val["text"]);
$typeTitre = $val["typeTitre"];
$pos = $val["pos"];
echo "\n
".nl2br(doHTML($titre))."\n";
echo "".eregi_replace($requete,"".$requete."",nl2br(doHTML($text)))."
\n
";
}
$result2 = @mysql_query($query2);
while($val = @mysql_fetch_array($result2)){
$titre = stripslashes($val["titre"]);
$text = stripslashes($val["text"]);
$typeTitre = $val["typeTitre"];
$pos = $val["pos"];
echo "\n
".nl2br(doHTML($titre))."\n";
echo "".eregi_replace($requete,"".$requete."",nl2br(doHTML($text)))."
\n
";
}
$result3 = @mysql_query($query3);
while($val = @mysql_fetch_array($result3)){
$titre = stripslashes($val["titre"]);
$text = stripslashes($val["text"]);
$typeTitre = $val["typeTitre"];
$pos = $val["pos"];
echo "\n
".nl2br(doHTML($titre))."\n";
echo "".eregi_replace($requete,"".$requete."",nl2br(doHTML($text)))."
\n
";
}
}
echo "
Nouvelle recherche";
}
deconnection();
echo "
";
require ('./footer.php'); ?>