I've got the following Problem:
I want to search for 2 words ('Telefon' and 'Terasse') in the same DB-Field ('FewoAusstattung').
Here is the example:
search.cgi?d=1&TypBetrieb=Ferienwohnung&catid=74&FewoAusstattung=Terrasse&FewoAusstattung=Telefon
There should be more than 1 results. But I don't get any results.
As a matter of fact I turned on the debug mode and I got the following:
...
...
46: SELECT ID FROM lsql_Links WHERE ( TypBetrieb LIKE '%Ferienwohnung%' AND isValidated = 'Yes' AND FewoAusstattung IN TelefoTerrass) )That looks somethiong strange for me... After the last "AND" that seems not to be a correct MySQL command!?
Where is the problem?
Please help me!
I want to search for 2 words ('Telefon' and 'Terasse') in the same DB-Field ('FewoAusstattung').
Here is the example:
search.cgi?d=1&TypBetrieb=Ferienwohnung&catid=74&FewoAusstattung=Terrasse&FewoAusstattung=Telefon
There should be more than 1 results. But I don't get any results.
As a matter of fact I turned on the debug mode and I got the following:
...
...
46: SELECT ID FROM lsql_Links WHERE ( TypBetrieb LIKE '%Ferienwohnung%' AND isValidated = 'Yes' AND FewoAusstattung IN TelefoTerrass) )That looks somethiong strange for me... After the last "AND" that seems not to be a correct MySQL command!?
Where is the problem?
Please help me!