It looks like the code on lines 11-31 is repeated just below it, so it can be deleted.
I don't see any code that filters based on the selected manufacturer. Maybe the code wasn't added to this page at all yet? I thought we saved a session variable with the current manufacturer and then used that to filter the recordset. This page doesn't seem to have it at all. I don't remember the database column name or session variable name we used, so I can't really give a code sample for what is missing. Maybe find it on the page where it is working.