grazie per la disponibilità nicko, ho fatto esattamente come mi hai detto (hai fatto bene a scegliere l'opzione "utonto")
ma continua a darmi come risultati anche articoli che hanno la parola ricercata SOLO nel testo dell'articolo
ecco come ho modificato
// search articles
if ( $sContent && $limit > 0 )
{
$query = 'SELECT a.title AS title, a.metadesc, a.metakey,'
. ' a.created AS created,'
. ' CONCAT(a.metakey, a.fulltext) AS text,'
. ' CONCAT_WS( "/", u.title, b.title ) AS section,'
. ' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,'
. ' CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END as catslug,'
. ' u.id AS sectionid,'
. ' "2" AS browsernav'
. ' FROM #__content AS a'
. ' INNER JOIN #__categories AS b ON b.id=a.catid'
. ' INNER JOIN #__sections AS u ON u.id = a.sectionid'
. ' WHERE ( '.$where.' )'
. ' AND a.state = 1'
. ' AND u.published = 1'
. ' AND b.published = 1'
. ' AND a.access <= '.(int) $user->get( 'aid' )
. ' AND b.access <= '.(int) $user->get( 'aid' )
. ' AND u.access <= '.(int) $user->get( 'aid' )
. ' AND ( a.publish_up = '.$db->Quote($nullDate).' OR a.publish_up <= '.$db->Quote($now).' )'
. ' AND ( a.publish_down = '.$db->Quote($nullDate).' OR a.publish_down >= '.$db->Quote($now).' )'
. ' GROUP BY a.id'
. ' ORDER BY '. $order
ho anche provato a togliere il "a.fulltext", ma non succede nulla
