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. Also another thing is that it is working on my local version of the site, there are no difference in files or database, they are a clone copy, however for some reason it won't work on the live site.

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/private/product_dvd.rar

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

Okey, i made a mistake, it isnt working on my local server either,

Can anyone see if they can see the problem with the coding ?