New Sidebox not showing Results

[Darkwander]

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/pr...roduct_dvd.rar

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

[Darkwander]

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 ?