';
$searchstring =mysql_escape_string($_GET['words']);
switch($_GET['mode'])
{
case"normal":
$sql="SELECT id,titolo,autore,note,cheys,coper,dove,
MATCH(autore,titolo,note,cheys)
AGAINST ('$searchstring') AS score FROM globa
WHERE MATCH(titolo,autore,note,cheys)
AGAINST ('$searchstring') ORDER BY score DESC";
break;
case"boolean":
$sql="SELECT id,titolo,autore,note,coper,dove,
MATCH(autore,titolo,note,cheys)
AGAINST ('$searchstring' IN BOOLEAN MODE) AS score FROM globa
WHERE MATCH(titolo,autore,note,cheys)
AGAINST ('$searchstring' IN BOOLEAN MODE) ORDER BY score DESC";
break;
}
// echo $sql;
//registrazione ricerca";
$base="globa";
$ip=@$REMOTE_ADDR;
$ref=@$HTTP_REFERER;
$addseakey = "INSERT INTO `isc_seakey` VALUES ('$searchstring', '$base', NOW( ), '$ip', '$ref')";
mysql_query($addseakey, $db);
// fine registrazione
$result=mysql_query($sql) or die (mysql_error());
$trovati = mysql_numrows($result);
//echo $addseakey;
echo " Trovati: $trovati ";
while($row=mysql_fetch_object($result))
{
echo "