This is my table
Zitat:
CREATE TABLE `appoencode` (
`id` int(10) NOT NULL auto_increment,
`code` char(1) NOT NULL default '',
`color` varchar(6) default NULL,
`tag` varchar(20) default NULL,
`style` tinytext,
`allowed` enum('0','1') NOT NULL default '1',
`active` enum('0','1') NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;
--
-- Dump dei dati per la tabella `appoencode`
--
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (1, '1', '4545AD', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (2, '2', '00B000', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (3, '3', '00B0B0', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (4, '4', 'B00000', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (5, '5', 'B000CC', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (6, '6', 'B0B000', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (7, '7', 'B0B0B0', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (8, '8', '0000FF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (9, '9', '999999', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (10, '!', '6666FF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (11, '@', '00FF00', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (12, '#', '00FFFF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (13, '$', 'FF0000', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (14, '%', 'FF00FF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (15, '^', 'FFFF00', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (16, '&', 'FFFFFF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (17, ')', '787878', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (20, 'g', 'AAFF99', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (21, 'G', '58D94F', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (22, 'k', '009966', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (23, 'o', 'FF9F3F', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (24, 'O', 'FF5400', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (25, 'q', 'FF9900', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (26, 'Q', 'FF6600', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (27, 't', 'F8DB83', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (28, 'T', '6B563F', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (29, 'u', '89D4FF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (30, 'U', '50BFFF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (31, 'v', 'AABBEE', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (32, 'V', '9A5BEE', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (33, 'x', 'FFCCFF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (34, 'X', 'FF99FF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (35, 'y', 'D391FF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (36, 'Y', '9900FF', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (37, 'z', 'F5EA90', NULL, NULL, '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (38, 'Z', 'AC9454', NULL, NULL, '', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (39, 'c', NULL, 'center', NULL, '', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (40, 'H', NULL, 'span', 'class=''navhi''', '0', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (41, 'b', NULL, 'strong', NULL, '0', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (42, '?', NULL, 'pre', NULL, '0', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (43, 'i', NULL, 'i', NULL, '0', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (44, 'n', NULL, 'br /', NULL, '0', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (45, 'r', NULL, 'right', NULL, '0', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (18, 'a', NULL, 'span', 'style="color:#000; background-color:#FFF"', '1', '1');
INSERT INTO `appoencode` (`id`, `code`, `color`, `tag`, `style`, `allowed`, `active`) VALUES (19, 'A', NULL, 'span', 'style="color:#FFFFFF; background-color:#FF0000"', '1', '1');