Search Help estorenow

[customgiftsshoppe]

Hi all,
Having problems with the search function and need help in fixing it.
I try to do a search and this comes up -
1064 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 ' , , cd.categories_description, cd.categories_id, c.parent_id from zen_categori' at line 1
in:
[SELECT DISTINCT c.categories_image, cd.categories_name, , , , cd.categories_description, cd.categories_id, c.parent_id from zen_categories_description cd, zen_categories c where cd.categories_id = c.categories_id and cd.language_id = '1' AND ((cd.categories_name LIKE '%drill%' OR cd.categories_description LIKE '%drill%') and (cd.categories_name LIKE '%bits%' OR cd.categories_description LIKE '%bits%') ) order by cd.categories_name]


Please help.

Thanks.

[customgiftsshoppe]

Let's try this again.
Using estorenow as a template, whenever someone uses the search, either top of page or from sidebox this error comes up -------

1064 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 ' , , cd.categories_description, cd.categories_id, c.parent_id from zen_categori' at line 1
in:
[SELECT DISTINCT c.categories_image, cd.categories_name, , , , cd.categories_description, cd.categories_id, c.parent_id from zen_categories_description cd, zen_categories c where cd.categories_id = c.categories_id and cd.language_id = '1' AND ((cd.categories_name LIKE '%drill%' OR cd.categories_description LIKE '%drill%') and (cd.categories_name LIKE '%bits%' OR cd.categories_description LIKE '%bits%') ) order by cd.categories_name]


I do not understand MYSQL and have no idea how to fix it.
Any help would be great.

Thanks.