Search
Left Quote    Treat your password like your toothbrush. Don't let anybody else use it, and get a new one every six months.
- Clifford Stoll    
Right Quote
 
[login] | [Register]
Forum Index » PHP and mySQL » Viewing Topic and Replies
Post Reply


        Viewing Topic: Pagination Help
  This user is offline  mumukobochi
  Subject: "Pagination Help" Posted: @ 10:05 am on Oct 22 2008   
Member #: 774
Rank: User - (1)
Since: 10/22/08
Posts: 1

i have here the mysql statement:

select code, fname, mname, lname, brname from table_name where date between '$start_date' and '$end_date' and code = '$code'

how can i paginate with three posted search string?
when i try to submit the values on html forms the first result is ok.. but when i try to click the next page link the values were gone and so the query would result to zero because there is no where clause.

most have only one posted search string or none..


    Viewed: 3,271 Times | Reply to This | To top
  This user is offline  David1159
  Subject: "re: Pagination Help" Posted: @ 6:27 pm on Oct 24 2008    

Member #: 526
Rank: User - (81)
Since: 12/27/07
Posts: 81
From: usa

k, I think I know what your saying. When your going to page 2 it doesn't know what information to grab because all those variable are not being transferred over to the new page.

You could use url with get methods. Than use a echo '<a href="som ething.php?act= '.$_GET['anyt hing'].'&quo t;>Page 2</a>';< br />
As you can see here, the URL is transferring f=4 and t=347 over pages.

Otherwise you could do it without using <a> tags. Just use $_POST when you click a button for Next Page it would send the information through a hidden input.




Coding is simply CST... Combining $hit Together. We make different $hit to run in unison correctly.

    Viewed: 3,249 Times | Reply to This | To top
Viewing Page: 1 of 1


1 |

You must be logged in to post on the forums. Login or Register








"AllSyntax.com" Copyright © 2002-2018; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank