[RESOLVED] Can someone help me with pagination?

[impactdesignpro]

I am trying to paginate this page and I am having no luck. I have tried different codes I found online but have had problems merging the two scripts. Here is my core source code. Can someone give me help????

<?php
include("admin/includes/config.inc.php");

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name ORDER BY year DESC, month DESC, day DESC";
$result=mysql_query($sql);
$num_rows = mysql_num_rows($result);

?>
<style type="text/css">
<!--
.smbold {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 11px; }
.smmainit {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-weight: normal;
	font-size: 11px;
	font-style: italic;
}
.smmain {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-weight: normal;
	font-size: 11px;
}
.link {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 11px; }
-->
</style>

<table width="100%" border="0" cellspacing="3" cellpadding="3">
  <tr>
    <td width="105" align="center"><span class="smbold">Date</span></td>
    <td width="264" align="center"><span class="smbold">Title</span></td>
    <td width="81" align="center"><span class="smbold">mp3</span></td>
    <td width="81" align="center" class="smbold"><div align="center">Download</div></td>
  </tr>
  <?php
while($rows=mysql_fetch_array($result)){
?>
  <tr>
    <td valign="top"><div align="center" class="smmain">
        <? echo $rows['month']; ?>/<? echo $rows['day']; ?>/<? echo $rows['year']; ?></span></td>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td class="smbold"><? echo $rows['title']; ?></span></span></td>
      </tr>
      <tr>
        <td class="smmainit"><? echo $rows['scripture']; ?></span></td>
      </tr>
      <tr>
        <td class="smmainit"><? echo $rows['ser_series']; ?></td>
      </tr>
      <tr>
        <td class="smmain"><? echo $rows['speaker']; ?></td>
      </tr>
    </table></td>
    <td align="center" valign="top"><a href="mp3/<? echo $rows['file']; ?>" class="link">Listen</a></td>
    <td align="center" valign="top"><div align="center"><a href="download.php?<? echo $rows['file']; ?>" class="link">Download</a></div></td>
  </tr>
  <?php
}
?>
</table>
<?php
mysql_close();
?>

[Jack_McSlay]

where it says

$sql="SELECT * FROM $tbl_name ORDER BY year DESC, month DESC, day DESC";
$result=mysql_query($sql);
$num_rows = mysql_num_rows($result);

replace with

if (@$_GET['s'] < 0) $start = 0;
else $start = (int) $_GET['s'];

if (@$_GET['a'] <= 0) $amount = 10;
else $amount = (int) $_GET['a'];

$sql="SELECT * FROM $tbl_name ORDER BY year DESC, month DESC, day DESC LIMIT $start,".($amount+1);
$result=mysql_query($sql);
$num_rows = mysql_num_rows($result);

if ($display_next = ($num_rows > $amount) ){
    $num_rows = amount;
}

and where it says

mysql_close();

replace with

if ($start > 0){
   $prev = $start - $amount;
   if ($prev < 0) $prev = 0;
   echo '<a href="thisScript.php?s='.$prev.'&a='.$amount.'">Previous</a>';
}
if ($display_next){
   echo '<a href="thisScript.php?s='.($start+$amount).'&a='.$amount.'">Next</a>';
}
mysql_close();

remember to replace "thisScript.php" with whatever your script is called

[impactdesignpro]

Thanks Jack, It worked!!!! You are a genius!!!!!!!!!!!