Pagination help. Desperate

[veledrom]

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');

[CzechRock3]

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

[veledrom]

Solved with the code listed in this page. Easy and simple to understand.

http://usefulscripts.wordpress.com/2007/10/26/pagination-using-php-mysql/