Here is the code to get the information from the database...
$pnSelect = "SELECT lot FROM properties WHERE status = 'Available'";
$pnSql = mysql_query($pnSelect, $db) or DIE("Unable to retrieve LOT data");
$pnFields = mysql_fetch_array($pnSql);
If I understand the current() function correctly I would use it this way...
$fCurrent = current($pnFields);
I'm not sure where to go from there. Thanks for your help.
Jef
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> sure, get an array with all your filenames, get the current position with
> $_SERVER['PHP_SELF'] and then use next() or prev().
>
> --
>
> Nicos - CHAILLAN Nicolas
> [EMAIL PROTECTED]
> www.WorldAKT.com - Hébergement de sites Internet
>
> "Jef" <[EMAIL PROTECTED]> a écrit dans le message de news:
> [EMAIL PROTECTED]
> > I need some help with the NEXT() and PREV() functions. I want to use
them
> > with a webpage to direct which page is viewed by the user. If NEXT is
> > selected then I would like the next information pulled from the
database.
> If
> > the PREV is selected I would like the previous information pulled from
the
> > database viewed.
> >
> > Any suggestions?
> > I have gone through the manual on these two functions but nothing has
> > worked.
> >
> >
> > Thank you,
> > Jef
> >
> >
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
