Ottima pillola

Per ricercare su due tabelle indipendeti faccio così


//parametri di ricerca
var $fulltext = "titolo,testo";
var $table = "dati";
var $table1 = "domande";
....
...
...
$sql = "SELECT *, MATCH($this->fulltext) AGAINST('*$this->key*' IN BOOLEAN MODE) AS tot FROM $this->table WHERE MATCH($this->fulltext) AGAINST('*$this->key*' IN BOOLEAN MODE) ORDER BY tot DESC
UNION
SELECT *, MATCH($this->fulltext) AGAINST('*$this->key*' IN BOOLEAN MODE) AS tot FROM $this->table1 WHERE MATCH($this->fulltext) AGAINST('*$this->key*' IN BOOLEAN MODE) ORDER BY tot DESC";



mi da errore dove sbaglio?