New Sidebox not showing Results

Greetings all;

I have made 2 sideboxes that allow users to search the site. The boxes consist of a box for DVD Categories and also Studio(s). When people click on the drop down box and select a "category" it is saying;

"There are no products to list in this category."

This isnt true because there are 3 products that are in the same category as well as other categories.

This is the following SQL for the Table "get_terms_to_filter"

INSERT INTO get_terms_to_filter VALUES ('manufacturers_id', 'TABLE_MANUFACTURERS', 'manufacturers_name');
INSERT INTO get_terms_to_filter VALUES ('music_genre_id', 'TABLE_MUSIC_GENRE', 'music_genre_name');
INSERT INTO get_terms_to_filter VALUES ('record_company_id', 'TABLE_RECORD_COMPANY', 'record_company_name');
INSERT INTO get_terms_to_filter VALUES ('dvd_category_id', 'TABLE_DVD_CATEGORY_DESCRIPTION', 'dvd_category_name');
INSERT INTO get_terms_to_filter VALUES ('dvd_type_id', 'TABLE_DVD_TYPE_DESCRIPTION', 'dvd_type_name');
INSERT INTO get_terms_to_filter VALUES ('dvd_studios_id', 'TABLE_DVD_STUDIOS', 'dvd_studios_name');

And here are the tables;

-- Structure de la table dvd_studios

DROP TABLE IF EXISTS dvd_studios;
CREATE TABLE dvd_studios (
dvd_studios_id int(11) NOT NULL auto_increment,
date_added datetime default NULL,
last_modified datetime default NULL,
dvd_studios_name varchar(128) NOT NULL default '',
dvd_studios_nickname varchar(128) default NULL,
dvd_studios_image varchar(64) default NULL,
PRIMARY KEY (dvd_studios_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

--
-- Structure de la table dvd_studios_info

DROP TABLE IF EXISTS dvd_studios_info;
CREATE TABLE dvd_studios_info (
dvd_studios_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
dvd_studios_url varchar(255) NOT NULL default '',
dvd_studios_info text NOT NULL,
PRIMARY KEY (dvd_studios_id,language_id),
KEY idx_music_category_name_zen (dvd_studios_url)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

-- Structure de la table dvd_category

DROP TABLE IF EXISTS dvd_category;
CREATE TABLE dvd_category (
dvd_category_id int(11) NOT NULL auto_increment,
date_added datetime default NULL,
last_modified datetime default NULL,
PRIMARY KEY (dvd_category_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

--
-- Structure de la table dvd_category_description

DROP TABLE IF EXISTS dvd_category_description;
CREATE TABLE dvd_category_description (
dvd_category_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
dvd_category_name varchar(32) NOT NULL default '',
dvd_category_description text NOT NULL,
PRIMARY KEY (dvd_category_id,language_id),
KEY idx_music_category_name_zen (dvd_category_name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

For a copy of the code it is downloadable from here; http://www.delightsoftheflesh.com/pr...roduct_dvd.rar

and a link to the site is http://www.delightsoftheflesh.com/store/