Fehler in MySQL-Abfrage
Tabelle: keywords, sets, set_names, links
Abfrage: SELECT links.url, links.text, links.description, sets.set_id,
set_names.set_name, keywords.word, sets.priority, COUNT(*)
FROM keywords, sets, links, set_names
WHERE (INSTR('Elektronik',keywords.word)=1 OR INSTR('Xoro',keywords.word)=1 OR INSTR('HTC',keywords.word)=1 OR INSTR('2225',keywords.word)=1 OR INSTR('Zoll',keywords.word)=1 OR INSTR('55cm',keywords.word)=1 OR INSTR('ready\',keywords.word)=1 OR INSTR('LCD',keywords.word)=1 OR INSTR('Fernseher',keywords.word)=1 OR INSTR('DVB',keywords.word)=1 OR INSTR('Tuner',keywords.word)=1 OR INSTR('MPEG4',keywords.word)=1 OR INSTR('DVD',keywords.word)=1 OR INSTR('Player',keywords.word)=1 OR INSTR('HDMI',keywords.word)=1 OR INSTR('schwarz',keywords.word)=1) AND sets.set_id=keywords.set_id
AND links.link_id=sets.link_id AND keywords.set_id=set_names.set_id
GROUP BY links.url ORDER BY sets.priority DESC
Fehlermeldung: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LCD',keywords.word)=1 OR INSTR('Fernseher',keywords.word)=1 OR I
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/virtual/_helioserv/zshop/include/toplinks.php on line 145