I have a page, shows 9 records per page (these are button designs by school
kids). I have it working where the page starts, shows the first page of the
whole list. Search form on the page, can search for first, last, or school.
What I'd like is to have the page always display a full set of images,
regardless of how many are returned by the query. So if I search exactly for
one record (right first name, last, school) it would return that record, but
also display 8 others.
My boss sees this as just showing the records around the one I search for,
no matter how I explain that a sql search pulls records that match the
query, its not like flipping through a book looking for a page. He may not
understand sql searches, but he does have a point -- a full page of designs
looks much better than a single design.
So how can I do this? I know how to check the number of records returned,
but what's the next step? Is there a way to pull more records in the search?
Can I select x number of random designs? Or even show the first x number
after the query results are shown.