Hi,

I have checked several examples but, i couldn't do the pagination. Please help me because i simply can't do it. I am stuck with my assignment because of this. Table is shown below.

Thanks

CREATE TABLE `country` (
  `code` varchar(255) default NULL,
  `rank` int(11) default NULL,
  `name` varchar(255) default NULL,
  `pop` varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `country` VALUES ('IN', '1', 'India', '150');
INSERT INTO `country` VALUES ('CH', '2', 'China', '900');
INSERT INTO `country` VALUES ('AL', '3', 'Algeria', '45');
INSERT INTO `country` VALUES ('NI', '4', 'Netherland', '140');
INSERT INTO `country` VALUES ('AU', '5', 'Austuria', '190');
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(255) default NULL,
  `rank` int(11) default NULL,
  `name` varchar(255) default NULL,
  `pop` varchar(255) default NULL
   PRIMARY KEY (`id`)
) TYPE = MyISAM;

I am assuming you are using a mysql database

This site has a good tutorial on it as well http://www.tonymarston.net/php-mysql/pagination.html

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.