CREATE TABLE `links` (
`link` varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `links` VALUES ('http://www.box.sk');
INSERT INTO `links` VALUES ('http://www.google.com');
INSERT INTO `links` VALUES ('http://www.mail.com');
INSERT INTO `links` VALUES ('http://www.php.net');
INSERT INTO `links` VALUES ('http://www.mysql.com');
INSERT INTO `links` VALUES ('http://www.apache.org');
INSERT INTO `links` VALUES ('http://www.yahoo.com');
INSERT INTO `links` VALUES ('http://www.daum.net');
INSERT INTO `links` VALUES ('http://www.msn.com');
INSERT INTO `links` VALUES ('http://www.alexa.com');
INSERT INTO `links` VALUES ('http://www.ebay.com');
INSERT INTO `links` VALUES ('http://www.dmoz.org');
INSERT INTO `links` VALUES ('http://sourceforge.net');
INSERT INTO `links` VALUES ('http://www.cnn.com');
INSERT INTO `links` VALUES ('http://www.microsoft.com');
INSERT INTO `links` VALUES ('http://www.wiki.com');
INSERT INTO `links` VALUES ('http://www.ibm.com');
INSERT INTO `links` VALUES ('http://www.nokia.com');
INSERT INTO `links` VALUES ('http://www.blogger.com');
After, your php pagenation codes, change with your own variables and run...
// change this variables
$config['host']='localhost';
$config['username']='root';
$config['password']='0000';
$config['database']='pagenation';
$config['table']='links';
$config['amount']=5;
// or include your own config page
// start
if(!$config['amount'] OR $config['amount']<=0){$config['amount']=5;}
if(!$HTTP_GET_VARS[page]){$page=0;}
if($HTTP_GET_VARS[page]<0){$page=0;}>
@mysql_connect($config['host'],$config['username'],$config['password']);
@mysql_select_db($config['database']);
$records=mysql_query('SELECT * FROM '.$config['table'].' LIMIT '.($page*$config['amount']).','.$config['amount']);
$selected=mysql_num_rows($records);
if($selected>0){$total=mysql_fetch_row(mysql_query('SELECT COUNT(*) FROM '.$config['table']));}
while($list=mysql_fetch_row($records)){echo $list[0].'
';}
$pageamount=ceil($total[0]/$config['amount']);
if($page>0){echo'Previous | ';}
for($i=0;$i<$pageamount;$i++){
if($page==$i){echo ($i+1).' ';}
else{echo' '.($i+1).' ';}}
if($pageamount>($page+1)){echo'| Next';}
?>
