page numbers

[dvwhi]

i have a donwloading page and there are more than 20 downloads and i want them on different pages but not different url for example downloads.php?pageid=2 but on the downloads page i dont want to have this code i want it to happen automatically here is wot i dont want :

if($pageid=="2"){
$var4="LIMIT 20 , 20";
}
$sql=mysql_query("SELECT * FROM uploads $var $var2 ORDER BY ID DESC $var4");

i need like a while loop or something any ideas?

[djjjozsi]

$query = "select * from uploads"; 
$result = mysql_query( $query );

$rowtotal=mysql_num_rows($result);
$row_per_page=10;
$numberofpages = ceil($rowtotal / $row_per_page);


$page=isset($_GET["page"])? int_val($_GET["page"]) : 0 ;
$actual=$page*$row_per_page;
$query.=" LIMIT $actual,$row_per_page";
$result = mysql_query( $query ); 

//fetch.........

build the links for the pages:

if(!empty($numberofpages))  {
for($i=0;$i<$numberofpages;$i++)
{
print("<a href=\"?page=$i\">[".($i+1)."]</a> ");
}
}