Hi,

I would like to enter a search value in a form (done in html) and send the value to the PHP file that would query the my-SQL database table and display the results showing a specified number of pages and allowing to move to the next page until all is done. NOTE: the form and the PHP file are two separate files.

Pliz help.

This is actually fairly easy. For the first page of results... let's say that you only want to show 10 items at a time. In your MySQL query, use the LIMIT keyword to limit the amount of rows that mysql returns.

For instance:


That query will get you the first 10 results from that query. The 0 after the LIMIT tells yuo where to start and the 10 tells you how many rows to get. Now, to get the next 10 results, all you have to change is this:


That will start at the 11th result (like arrays 0 is the first element... so 10 is actually the 11th) and get the next 10.

So one easy way to do that in PHP is to pass the values of where to start and how many elements to get as URL arguments.


(I only put that in code tags because it wouldn't quit hyperlinking the text. It's only an example... not a link)

Then you can use those values to insert into your MySQL query and viola. The lowlimit variable holds the value of where to start, and the n variable tells you how many rows to return. So, all you have to alter in each pages "NEXT" link is to add 10 to the lowerlimit variable. As for the "PREVIOUS" link, you just need to subtract 10.

wow that just helped me out a lot thanx TreyAU21 ...i was always doing that by selecting, adding, all rows into one large array and then displaying certain rows within the array doh! Is this method secure to injection attacks or what can u do to allow only relevant variables being allowed in the query?