I have been working on figuring out a way to add a filter to my client's site so that customers can search by one of the fields in the custom product that I made for them. I finally realized that I could make a filter sidebox like the music genre or manufacturers, but I have hit a snag.

the box doesn't list the "drive types", but still allows for one to select types anyway, then comes up with this error:

1054 Unknown column 'pme.drive_type_id' in 'where clause'
in:
[select distinct c.categories_id as id, cd.categories_name as name from zen_products p, zen_products_to_categories p2c, zen_categories c, zen_categories_description cd, zen_product_drive_extra pme where p.products_status = 1 and pme.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '1' and pme.drive_type_id = '6' order by cd.categories_name]

I keep on looking up this error and finding that it generally has to do with people running an old version of zen cart on mysql5, but this isn't the problem. I am running zen cart 1.3.7 on my sql 4.1.

does anyone see the problem? is it just a typo? tell me where, please.

I will post all of my code in the next post.