Re: NEXT() and/or PREV()

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 <nicos@php.net> wrote in message news:20021007235413.73184.qmail@pb1.pair.com... > 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 > nicos@php.net > www.WorldAKT.com - Hébergement de sites Internet > > "Jef" <dragonr@xmission.com> a écrit dans le message de news: > 20021007220352.2893.qmail@pb1.pair.com... > > 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 > > > > > >