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/