SELECT id,o_name,o_surname,o_nick,o_date_birth,o_rank,o_division,r_date,r_on_line,img_name,img_extension,img_mime
FROM map WHERE lang = 'pl' AND invisible = '0'
ORDER BY o_surname
CREATE TABLE `map` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`o_name` text NOT NULL,
`o_surname` text NOT NULL,
`o_nick` text NOT NULL,
`o_date_birth` text NOT NULL,
`o_rank` text NOT NULL,
`o_division` text NOT NULL,
`o_district` text NOT NULL,
`p_full_name` text NOT NULL,
`r_place` text NOT NULL,
`r_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`r_content` longtext NOT NULL,
`r_on_line` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`r_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`img_name` text NOT NULL,
`img_extension` text NOT NULL,
`img_mime` text NOT NULL,
`invisible` int(11) NOT NULL DEFAULT '0',
`lang` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=167 ;