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 dev@elstudion.com
----- Original Message -----
From: "Harpreet" <harpreet@crispincorp.com>
To: "Croskerry, Dan" <dcrosker@hpl.ca>; <php-windows@lists.php.net>
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" <dcrosker@hpl.ca>
> To: <php-windows@lists.php.net>
> 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:harpreet@crispincorp.com]
> > Sent: Wednesday, August 27, 2003 2:33 PM
> > To: php-windows@lists.php.net
> > 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
