creating first next, previous and page links

[NTFS]

this is the page code, just want to display first, next, previous and last sms, i tried myself and got nothing else of errors,

          

<?php

   $sql = "select d.title, d.sms, d.hits, d.rating, d.userid, c.category from sms d, categories c where d.smsid = $smsid and c.catid = d.catid";
   $result = mysql_query($sql ,$db);

   if ($myrow = mysql_fetch_array($result)) {
	  do {
         $pagetitle = $myrow["title"];
         $directions = $myrow["sms"];
         $hits = $myrow["hits"];
         $smsrating = $myrow["rating"];
         $userid = $myrow["userid"];
         $category = $myrow["category"];
      } while ($myrow = mysql_fetch_array($result));

   }


   $hits++;

   $sql = "update sms set hits = $hits where smsid = $smsid";

   $result = mysql_query($sql ,$db);

   ?>

      <div id="sv"><? printf($pagetitle);?></div> 
      <div id="lsm"><?php printf($directions); ?> </div> 


<!-- next previous first page last page -->
          <div id="sn"> 
            <div align="left"><a href="#">&laquo; previous</a> <a href="#">next msg &raquo;</a> </div> 
          </div> 
 <!-- next previous first page last page -->

thanks

[leatherback]

Search for pagination on this forum, or look at the tutorials at phpbuilder.com. there is a very good one on pagination