Simple Recordset Paging Problem - PHP, MySql, Dreamweaver

This project was awarded to sureshdevi for $34 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
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: [url removed, login to view], [url removed, login to view], and SQL and XLS database samples. (Simplified versions. The actual database has 70+ fields. I've included only four.)

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online