this is my table:
CREATE TABLE IF NOT EXISTS `artikulli` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`autori` varchar(100) CHARACTER SET utf8 NOT NULL,
`perkthyesi` varchar(100) CHARACTER SET utf8 NOT NULL,
`category` varchar(100) CHARACTER SET utf8 NOT NULL,
`titulli` varchar(350) CHARACTER SET latin1 NOT NULL,
`nen_titulli` varchar(400) CHARACTER SET utf8 NOT NULL,
`url_alias` varchar(400) COLLATE utf8_unicode_ci NOT NULL,
`burimi` varchar(200) CHARACTER SET utf8 NOT NULL,
`teksti` text CHARACTER SET latin1 NOT NULL,
`intro` text COLLATE utf8_unicode_ci NOT NULL,
`picture` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
`date` int(11) NOT NULL,
`views` int(10) NOT NULL,
`is_perhershme` int(10) NOT NULL,
`etiketat` varchar(500) CHARACTER SET utf8 NOT NULL DEFAULT '',
`featured` tinyint(10) NOT NULL,
`ft_order` int(10) NOT NULL,
`show_picture` int(10) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=51 ;
id is the unique Id of each article, i get articles with $_GET;
so is this the right field to create index?