Treba da pretrazujem vise povezanih tabela (povezanih id-om) u fulltext modu.
Do sada sam imao sledeci kod :
"SELECT *, MATCH ( $polja ) AGAINST ('$izraz') AS score FROM tabela WHERE MATCH ( $polja ) AGAINST ('$izraz') ORDER BY score DESC";
(polja se genericki definisu).
Sada treba da u odredjenim tabelama dodam relaciju tipa
"SELECT *, MATCH ( $polja ) AGAINST ('$izraz') AS score FROM tabela
LEFT JOIN tabela2 ON (tabela.id2 = tabela2.id)
WHERE MATCH ( $polja ) AGAINST ('$izraz') ORDER BY score DESC";
ili slicno. Potpuno sam zbunjen :(
trenutno dobijam
Column: 'kommentar' in field list is ambiguous
gresku, sa kodom koji odgovara ovom odozgo.
Java User Group Karlsruhe
IT Dan - Srbija
Officer, I saw the driver who hit me - his name was Johnny Walker.