MATCH AGAINST problem...

[kodlcan]

I have followin':

CREATE TABLE `PKZ_ciselnik` (
  `ciselnik_PKZ` int(10) unsigned NOT NULL default '0',-- id
  `ciselnik_nazevzbozi` varchar(255) NOT NULL default '',-- product name
  `ciselnik_nazevpodskupiny` varchar(255) NOT NULL default '',-- subclass name
  `ciselnik_nazevvyrobce` varchar(255) NOT NULL default ''-- manufacturer
) ENGINE=MyISAM DEFAULT CHARSET=cp1250;

CREATE TABLE `lekarny` (-- reseller
  `lekarna_id` tinyint(3) unsigned NOT NULL default '0',--id
  `lekarna_jmeno` varchar(255) NOT NULL default ''--name
) ENGINE=MyISAM DEFAULT CHARSET=cp1250;

CREATE TABLE `zbozi_vse` (
  `zbozi_PKD` int(10) unsigned NOT NULL default '0',--id
  `zbozi_mnozstvi` int(11) NOT NULL default '0',--amount
  `zbozi_cenasdph` float unsigned NOT NULL default '0',--price
  `zbozi_lekarna` tinyint(3) unsigned NOT NULL default '0',--drugstore number
  `zbozi_SID` int(10) unsigned NOT NULL default '0'--drugstore internal number
) ENGINE=MyISAM DEFAULT CHARSET=cp1250;

The problem is that I need custom this working schema to work with Score parameter to sort it by relevancy:
I have this: and it works...

SELECT ciselnik_PKZ, ciselnik_nazevzbozi, ciselnik_nazevvyrobce, lekarna_jmeno, zbozi_mnozstvi, zbozi_cenasdph FROM PKZ_ciselnik, zbozi_vse, lekarny WHERE (PKZ_ciselnik.ciselnik_PKZ = zbozi_vse.zbozi_PKD AND zbozi_vse.zbozi_lekarna = lekarny.lekarna_id) AND MATCH(ciselnik_nazevzbozi, ciselnik_nazevvyrobce) AGAINST('+"$query1 +$query2' IN BOOLEAN MODE);

but how to custom it like this: ??

SELECT *, MATCH(title, body) AGAINST('$keyword') AS score
FROM articles
WHERE MATCH(title, body) AGAINST('$keyword')
ORDER BY score DESC

The problem is how to acomplish to implement the part where two tables are joined with WHERE with MATCH...AGAINST part. When I simply rewrite sample with my data like this "WHERE (PKZ_ciselnik.ciselnik_PKZ = zbozi_vse.zbozi_PKD AND zbozi_vse.zbozi_lekarna = lekarny.lekarna_id) AND MATCH (ciselnik_nazevzbozi, ciselnik_nazevvyrobce) AGAINST ('paralen')AS Score ORDER BY Score;
mySQL reports error in the "...AS Score part".


Could anyone help me with??

ThnX a lot.

Kodl

[kodlcan]

AGAINST('+"$query1 +$query2...... BAD ONE.
this is correct:
AGAINST('+$query1 +$query2...

I made this one when I rewrote this here. This is not the problem. :D

[fenway]

You can order by the value returned by MATCH() -- the optimizer won't have to run it twice, AFAIK.