apply pagination to search results, limit pages

[Evgeniya]

Need help to correct my cording! I want to limited search results by 5 items on one page.

Don't know how correctly to add limit:  "limit $page1,5".

 

When I add it:     $sql = "SELECT * FROM data GROUP BY city ORDER BY city limit $page1,5";

it doesn't limit searching result by pages.   

 

search3.phpFetching info...

[arbitrageur]

Just add:

LIMIT 0,5

To the end of your sql query.

 

You're going to need more logic to deal with multiple pages (handle that with php), and calculate the # of results you want per page.

[QuickOldCar]

An old pagination tutorial for your old code.

http://www.phpfreaks.com/tutorial/basic-pagination

[mac_gyver]

  On 11/20/2014 at 1:05 AM, Evgeniya said:

When I add it:     $sql = "SELECT * FROM data GROUP BY city ORDER BY city limit $page1,5";

it doesn't limit searching result by pages.

that's because the purpose of that query is to get a unique list of city names, to produce the select/option list, that is used as a filter for the actual data retrieval query. that query isn't the one that retrieves the matching data and it isn't where the limit term belongs.