Project Description:
I'm certain that this is a simple thing for someone with more experience than I have. I need some simple help with recordset paging to show the results of a query. I'm creating a search interface in php for a database of museum specimens. I've set up a simple search page and result page and I have some basic queries working and displaying results. Example below, searches for all specimens of a particular genus and species.
SELECT CatNo, Genus, Species
FROM invertebrates
WHERE ((Species = cSpecies or cSpecies='any') AND (Genus = cGenus or cGenus='any'))
The problem is with displaying a long list of records on the result page, where the number of records is greater than what I want to display on the screen. I've set up recordset paging with next, previous, ... on other projects but I'm not able to make it work here. The initial set of records shows up just fine, and the current record number and total records are shown correctly. But, selecting another page of results causes the query to break and no records are returned. The recordset query loses the variables passed from the search page and no results are shown. (Don't laugh. I know I should be able to sort this out.)
Note: the primary query is on the result page. But the search page also links to the database to create the list of pulldown options in select fields for choosing Genus, Species, and (eventually) other search criteria.
Files attached: search.php, result.php, and SQL and XLS database samples. (Simplified versions. The actual database has 70+ fields. I've included only four.)
