Working on a web page to display button designs submitted by school kids.
Access db, image filename in each record, etc etc.
I have a search form (first, last, school) and an html table where the
designs are shown all in a single cell. I have the page working great if I
don't try any paging, and if only a few records are returned. Not suitable
for final version - likely more than 9 designs will be returned by some
I searched in books and on the net and found many descriptions of paging,
several of which I have followed to learn the technique. Sample pages work
like a champ if I code in the sql directly, ie don't use a form.
BUT NONE OF THE SAMPLES USE A FORM.
When I try to combine the two techniques, paging and a form, I get the first
page fine (it returns the correct records, shows the correct number of
pages, the "previous" doesn't show, the "next" appears) but when I click on
the next (or key in "?page=2" in the url) it returns all records. Even if I
key in "?page=1", which should show the first page, it shows all records.
So I'm missing something. I use a "like" operator in the sql, so I can get
partial names to work. Wonder if that might be part of the problem.
I'm at home now so I don't have the code. I can post that if needed. Is
there some incompatibility with a form creating the sql string, and paging
Any help is appreciated!