Creating a Record list with Prev / Next ability

How do I create an html list using php and mysql that also has the
previous and next funtionality.

re: Creating a Record list with Prev / Next ability

wqmmnm wrote:You need to determine how many items are in the list and remember where
you are in the list.

The list comes from somewhere - i.e. a database, flat file, etc. You
can determine from that how many items are in the list. Start with the
current position as 0 and keep track of it (i.e. in a session variable).

When they press next, increment the current position until you reach the
end of the list. If they press prev, decrement the current position
until you reach the beginning of the list. Then display the item at
that position in the list.

If you're displaying multiple items on a page, the current position
becomes the page number and you just need to account for the fact you
have 8 (or however many) items per page instead of 1.

From your question, it's hard to give you any more specific information.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

re: Creating a Record list with Prev / Next ability

wqmmnm wrote:What like this? http://www.greenhithe.org.uk/php/allfr_a.php

If so I can give you the code.

Paul
--
Add an underscore after the p to reply

re: Creating a Record list with Prev / Next ability

On Mar 13, 9:28*am, Jerry Stuckle <jstuck...@attglobal.netwrote:Okay how do I keep track of the records that I am on after I hit next
or previous links. Do I use a hidden variable and just capture it use
GET or POST methods. My biggest things is how do you keep track of
what record you are on now to determine what the next records should
be.

Thanks,

Walter Q. Mason III

re: Creating a Record list with Prev / Next ability

On Mar 13, 5:45 am, wqmmnm <wqm...@gmail.comwrote:I had the same issue to solve.

PEAR/Pager

Works like dream! The NEXT/PREVIOUS needs a little "help" to look like
i want, but that's a minor details.

And here's a great example/tutorial on how to use it!

http://devzone.zend.com/article/2418...ith-PEAR-Pager

Walter

re: Creating a Record list with Prev / Next ability

wqmmnm a écrit :A simple $start using GET is enough. Your script includes the number of
items (or it also can be a GET variable), you display X items from
$start, next page is $start + x, previous is $start - x, check for the
max value (and don't display next), check for the min value (if $start =
0 - and don't display previous)

--
Guillaume

re: Creating a Record list with Prev / Next ability

wqmmnm wrote:You could use hidden either hidden or session variables or a cookie.
For something like this, I'd probably just use a hidden variable, but
any of them will work.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

re: Creating a Record list with Prev / Next ability

wqmmnm wrote:http://www.allsyntax.com/tutorials/P...with-PHP/1.php

Found this while looking for good newbie tutorials.

Paul
--
Add an underscore after the p to reply