Pagination d'un résultat de requête

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE TABLE `xmen` ( 
  `id` int(11) NOT NULL auto_increment, 
  `personnage` varchar(255) NOT NULL default '', 
  `acteur` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; 
  
INSERT INTO `xmen` VALUES (1, 'Wolverine', 'Hugh Jackman'); 
INSERT INTO `xmen` VALUES (2, 'Magneto', 'Ian McKellen'); 
INSERT INTO `xmen` VALUES (3, 'Professeur X', 'Patrick Stewart'); 
INSERT INTO `xmen` VALUES (4, 'Docteur Jean Grey', 'Famke Janssen'); 
INSERT INTO `xmen` VALUES (5, 'Tornade', 'Halle Berry'); 
INSERT INTO `xmen` VALUES (6, 'Cyclope', 'James Marsden'); 
INSERT INTO `xmen` VALUES (7, 'Malicia', 'Anna Paquin'); 
INSERT INTO `xmen` VALUES (8, 'Dents-de-Sabre', 'Tyler Mane'); 
INSERT INTO `xmen` VALUES (9, 'Crapaud', 'Ray Park'); 
INSERT INTO `xmen` VALUES (10, 'Mystique', 'Rebecca Romijn'); 
INSERT INTO `xmen` VALUES (11, 'Pyro', 'Alex Burton');