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?