Jump to content

apply pagination to search results, limit pages


Evgeniya

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
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.