In Progress

Simple Recordset Paging Problem - PHP, MySql, Dreamweaver

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.)

Skills: Adobe Dreamweaver, MySQL, PHP

See more: dreamweaver recordset paging problem, recordset paging working dreamweaver, sql paging query dreamweaver, paging php dreamweaver, php recordset paging problem, recordset paging dreamweaver, dreamweaver php database paging next, paging recordset php example simple, simple query, mysql and sql, projects php sql, mysql sort, sort criteria, mysql number sql, loses, php mysql sql example, recordset, php search page, php projects sql, mysql page break, mysql paging, dreamweaver php mysql, simple paging, php mysql database query, sql problem

About the Employer:
( 2 reviews ) why is this needed?, United States

Project ID: #2566407

Awarded to:

sureshdevi

I can solve this pagination problem in php/mysql script. I can complete this work in next few hours.

$34 USD in 1 day
(508 Reviews)
7.3

5 freelancers are bidding on average $53 for this job

onedeepen

I can help you. Please check PMB for portfolio and other details. regards

$30 USD in 1 day
(37 Reviews)
5.9
luantnd

Hi,I'm ready fix it

$120 USD in 1 day
(32 Reviews)
4.4
ariesta1503

Hi. I understand what you need.

$50 USD in 1 day
(39 Reviews)
4.3
Budiawan

Trust me. I Can Make It For You.

$30 USD in 1 day
(0 Reviews)
0.0