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!

MMm.. does this work?

search.cgi?FewoAusstattung=Telefon&FewoAusstattung=Terasse&bool=AND

?

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

I've tried allready and I get:
42: SELECT * FROM lsql_Links WHERE ( isValidated = 'Yes' AND FewoAusstattung IN TerassTelefo) )
ORDER BY bStars ASC
LIMIT 0, 25It seems to be the same problem:
"AND FewoAusstattung IN TerassTelefo)"
There is ")" to much and the "TerassTelfo" looks also like a bad "string function"...

Where are the scripts located, which build the query-string?

Hi,


/admin/Links/User/Search.pm, I believe.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!