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('Haushalt',keywords.word)=1 OR INSTR('Bierbaum',keywords.word)=1 OR INSTR('183150',keywords.word)=1 OR INSTR('Feinbiber',keywords.word)=1 OR INSTR('Bettw',keywords.word)=1 OR INSTR('Elch\',keywords.word)=1 OR INSTR('4597',keywords.word)=1 OR INSTR('135x200',keywords.word)=1 OR INSTR('blau',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 '4597',keywords.word)=1 OR INSTR('135x200',keywords.word)=1 OR IN
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
E l e k t r o g e r ä t e - Küche & Haushalt: Bierbaum 183150 Feinbiber Bettwäsche \\\"Elch\\\" 4597 135x200 cm blau