If you are getting SQL errors with your OSCommerce install please try applying this patch.

You need to change one section in index.php and one in advance search_result.php please see this file for the changed code on those pages.

The newer OSCommerce from around Sept-Oct 2006 or so, doesn't have this problem.