Advanced Search Plus

[rmkiser]

I have looked and tried to find the answer to this. But, I can't. I want to allow my customers to search just by the price. But, if they do, they get the following error.

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 'order by e.toc_chapter, e.toc_sort_order, e.pages_title' at line 1
in:
[SELECT * from ezpages e where order by e.toc_chapter, e.toc_sort_order, e.pages_title]

Does anyone have any idea how to fix this?

[FrankDeRosa]

Have you modified the module? I just tried searching for a price 0n my site and I found products that matched.

Frank