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

Kemahiran: Adobe Dreamweaver, MySQL, PHP

Lihat lagi: 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

Tentang Majikan:
( 2 ulasan ) why is this needed?, United States

ID Projek: #2566407

Dianugerahkan kepada:


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

$34 USD dalam sehari
(508 Ulasan)

5 pekerja bebas membida secara purata $53 untuk pekerjaan ini


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

$30 USD dalam sehari
(37 Ulasan)

Hi,I'm ready fix it

$120 USD dalam sehari
(32 Ulasan)

Hi. I understand what you need.

$50 USD dalam sehari
(39 Ulasan)

Trust me. I Can Make It For You.

$30 USD dalam sehari
(0 Ulasan)