If I understood you correct you could do something like this with mysql:
<code>
$recnum = (isset($_GET["recnum"])) ? $_GET["recnum"] : 1;
$q = "SELECT * FROM table LIMIT ".$recnum.",1";
$r = mysql_query($q, $link_id);
$row = mysql_fetch_object($r);
print ($row->some_field);
print ("<a href='thispage.php?recnum=".max($recnum-1,1)."'>PREV</a>");
print ("<a href='thispage.php?recnum=".($recnum+1)."'>NEXT</a>");
mysql_free_result($r);
</code>
.bobo [EMAIL PROTECTED]
----- Original Message -----
From: "Harpreet" <[EMAIL PROTECTED]>
To: "Croskerry, Dan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 5:38 AM
Subject: Re: [PHP-WIN] Displaying one record per page
> MSSQL and MYSQL both. I need a solution for both as the web app is going
to
> run on b oth databases.
>
> ----- Original Message -----
> From: "Croskerry, Dan" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 27, 2003 4:16 PM
> Subject: RE: [PHP-WIN] Displaying one record per page
>
>
> > What database are you using? MySQL, MSSQL, Oracle...?
> >
> > -----Original Message-----
> > From: Harpreet [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, August 27, 2003 2:33 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-WIN] Displaying one record per page
> >
> >
> > I have a sql command that returns more then one rows. I want to display
> one
> > record per page using NEXT to show the other records. Each page
displaying
> > one record.
> >
> > Help is appreciated.
> >
> > Regards,
> > Harpreet Kaur
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
