Gossamer Forum
Home : Products : Gossamer Links : Discussions :

search didn't work corectly?

Quote Reply
search didn't work corectly?
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!
Subject Author Views Date
Thread search didn't work corectly? icarus 2530 Mar 19, 2008, 11:29 AM
Thread Re: [icarus] search didn't work corectly?
Andy 2461 Mar 19, 2008, 11:41 AM
Thread Re: [Andy] search didn't work corectly?
icarus 2458 Mar 19, 2008, 11:47 AM
Post Re: [icarus] search didn't work corectly?
Andy 2450 Mar 19, 2008, 11:49 AM