Jump to content

PHP Paging from Recordset Search Results


Eon_Parabol

Recommended Posts

hi there guys,

Im trying to have a paging through records on a page. Ive managed to do so using Recordset Paging in Dreamweaver and it works fine, for a totalrow region.

However, when I am displaying records from a search eg. 
SELECT *
FROM my_table
WHERE name = 'colname'
ORDER BY id DESC

'colname'      --    $_POST['select_name']

When I use the links I have made  <<Last  <Previous  Next>  Last>>
I get blank pages,

Am I on the right track in saying that it is losing the recordset on the next page of records?
Therefore displaying no records.

Is there something I have to add to either the Paging Statements, or my SQL

Can you help me? Have I made sense?

Regards
Warren


Link to comment
https://forums.phpfreaks.com/topic/34537-php-paging-from-recordset-search-results/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.