View Single Post
Go4Expert Member
19Feb2011,10:35  
underground_devil's Avatar
i send you my simple code for pagination

PHP Code:
<?php
$q
="SELECT * FROM table_name";
$p=mysql_query($q);
$nr=mysql_num_rows($p);
$t=$nr/5;
$lim=$_GET['start']*;

$q="SELECT * FROM table_name LIMIT $lim,5";
$p=mysql_query($q) or die('query error');
while(
$r=mysql_fetch_array($p))
{
    echo 
$r['user']."<br>";   // fetching data
}

for(
$i=0;$i<=$t;$i++)
{
    
$j=$i+1;
    echo 
" [ <a href=index.php?p=5&start=$i>".$j."</a>] | "// change according to you page
}


?>

may be there would some easy method but i like to use this simple code