Here I have a problem in this code ..

I want to specify the 4 values in each page .. But I can not ... So far there is a problem, I think, in limit

<?php 

if(!isset($_GET["page"])) 
{ 
$page=1; 


include ("connect.php");  
} 
else 
{ 
$page= intval($_GET['page']); 
} 
$max=4; 
$from=($max*$page)- $max; 
$sql = mysql_query("select * from uploads,members,rooms where uploads.MemberID = members.MemberID and uploads.RoomID = rooms.RoomID and UploadCategory='L' order by UploadID desc limit $from,$max  ");  
$num_sql = mysql_num_rows($sql); 

?> 


<table width="400" border="0" cellspacing="1" cellpadding="0"> 
<tr> 
<td><form name="form1" method="post" action=""> 
<div align="center"> 
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC"> 
<tr> 
<td bgcolor="#FFFFFF">&nbsp;</td> 
<td colspan="4" bgcolor="#FFFFFF"> 
<p align="center"><font size="4"> file</font></td> 
</tr> 
<tr> 
<td align="center" bgcolor="#FFFFFF">#</td> 

<td align="center" bgcolor="#FFFFFF"><strong>member</strong></td> 

<td align="center" bgcolor="#FFFFFF"><strong> Name</strong></td> 

</tr> 
</div> 

<?php 


//$sql1 = mysql_query("select * from book order by id desc limit $from,$max "); 
//$num_sql1 = mysql_num_rows($sql1); 
$pages=ceil($num_sql/$max); 
$num = mysql_num_rows($sql); 
//$result = mysql_query("SELECT * FROM book order by id"); 

while($row = mysql_fetch_array($sql)) 


  { 

     ?> 




<tr> 
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo $row['UploadID']; ?>"></td> 
<td bgcolor="#FFFFFF"> <?php echo $row[MemberName]. "<br />";  ?></td> 


<td bgcolor="#FFFFFF"> <?php echo $row[UpoadName]."<br />";  ?></td> 



</tr> 

<?php 

} 

?> 

<tr> 
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="delete"></td> 
</tr> 


<?php 


if($page>1) 
{ 
$prev=$page-1; 
echo"<a href=".$PHP_SELF."?page=$prev\"></a>"; 
} 
for($i=1;$i<=$pages;$i++) 
{ 
if($page==$i) echo" [$i] "; 
else 
{ 
echo" <a href=".$PHP_SELF."?page=$i\">$i</a> "; 
} 
} 
if($page<$pages) 
{ 
$next=$page+1; 
echo"<a href=".$PHP_SELF."?page=$next\"></a>"; 
} 
 ?> 


</html> 

thanks alote