archael

first of all my script is a perl script. It takes a query in the environment and cuts it into exactly what i want. Can be a combination of up to 3 search terms and a category. There is no problem there.

On my SELECT part for my query, something goes wrong.

All my terms are always perfect whether only 1 or 3 or even none are present.

Here is what i have:

SELECT * FROM Table WHERE description like '%$search%' OR description like '%$search2%' order by ID limit 0,144;

When i have only 1 search term its fine, when i have 2 or 3 it messes up, have no idea why.

Anyone might know?

Jon