Hi Rudy…erm, it doesnt work …i get
#1054 - Unknown column 'diagrams.diagid' in 'field list'
I dont know if itll help, but heres structures and a bit of data
CREATE TABLE IF NOT EXISTS `collections_en` (
`colid` int(11) NOT NULL AUTO_INCREMENT,
`colname` varchar(255) COLLATE utf8_bin NOT NULL,
`famno` varchar(3) COLLATE utf8_bin NOT NULL,
`thumb` varchar(255) COLLATE utf8_bin NOT NULL,
`main` varchar(255) COLLATE utf8_bin NOT NULL,
`new` varchar(2) COLLATE utf8_bin NOT NULL,
`feature` varchar(2) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`colid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=34 ;
--
-- Dumping data for table `collections_en`
--
INSERT INTO `collections_en` (`colid`, `colname`, `famno`, `thumb`, `main`, `new`, `feature`) VALUES
(1, 'Anilines', '4', 'Anilines_1S.jpg', 'Anilines_1.jpg', '', ''),
CREATE TABLE IF NOT EXISTS `family_en` (
`famid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(120) NOT NULL,
`text` text NOT NULL,
`thumb_image` varchar(255) NOT NULL,
`main_image` varchar(255) NOT NULL,
`alt` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`home_thumb` varchar(255) NOT NULL,
PRIMARY KEY (`famid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `family_en`
--
INSERT INTO `family_en` (`famid`, `name`, `text`, `thumb_image`, `main_image`, `alt`, `title`, `home_thumb`) VALUES
(1, 'Aluminium', '<p>A traditional collection of wooden profiles covered by various aluminium foils</p>', '', 'fam_metallic.jpg', '', '', 'metalic.jpg');
CREATE TABLE IF NOT EXISTS `products` (
`prodid` int(11) NOT NULL AUTO_INCREMENT,
`code1` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
`code2` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
`thumb` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`famlink` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
`collink` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
`mainimage` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`desc_en` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`desc_it` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`prodid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
--
-- Dumping data for table `products`
--
INSERT INTO `products` (`prodid`, `code1`, `code2`, `thumb`, `famlink`, `collink`, `mainimage`, `desc_en`, `desc_it`) VALUES
(1, '7002', '0525', '7002', '4', '6', '', '', '');
CREATE TABLE IF NOT EXISTS `diagrams` (
`did` int(11) NOT NULL AUTO_INCREMENT,
`diagid` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
`dthumb` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`dmain` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`wid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`hei` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `diagrams`
--
INSERT INTO `diagrams` (`did`, `diagid`, `dthumb`, `dmain`, `wid`, `hei`) VALUES
(1, '7002', '7002', '', '', '');