Index: trunk/kernel/include/searchitems.php =================================================================== diff -u -r13 -r120 --- trunk/kernel/include/searchitems.php (.../searchitems.php) (revision 13) +++ trunk/kernel/include/searchitems.php (.../searchitems.php) (revision 120) @@ -140,7 +140,8 @@ { $limit = "LIMIT $Start,$PerPage"; } - $sql = "SELECT * FROM ".$this->ResultTable." ".$limit; + $sql = "SELECT * FROM ".$this->ResultTable." ".$limit; + $this->Clear(); $rs = $this->adodbConnection->Execute($sql); return $this->Query_Item($sql); @@ -436,7 +437,7 @@ $this->adodbConnection->Execute("DROP TABLE ".$this->ResultTable); //$indexSQL = "(INDEX(Relevance), INDEX(ItemId), INDEX(ItemType), INDEX sorting (EdPick,Relevance)) "; $full_sql = "CREATE TABLE ".$this->ResultTable." ".$indexSQL.$SelectSQL; -// echo $full_sql."
\n"; + //echo $full_sql."
\n"; $this->adodbConnection->Execute($full_sql); //echo $this->adodbConnection->ErrorMsg()."
\n"; $objSession->SetVariable("Search_Keywords",$this->Phrase); @@ -448,6 +449,8 @@ $this->adodbConnection->Execute($full_sql); //echo $this->adodbConnection->ErrorMsg()."
\n"; } + //Here we need to remove found items which was found by HTML tags matching keywords + //$this->adodbConnection->Execute("DELETE FROM ".$this->ResultTable." WHERE ItemId = 13 AND ItemType = 4"); } function BuildIndexes()