Search Results show more than query results.

[Mazer]

I have made duplicated the advanced_search_result.php and made some changes to reflect parameters on a custom form. The problem I am having is that the search results say it returns more than the actual query. It returns the results pages and the rest of the pages are empty?

 

Does anyone have any tips that would help the rendered output match the query results

[Mazer]

Example here: http://www.jollysofttoys.co.uk/assistant_search_result.php?Age_Range=0&Toys_by_Price=32&manufacturers_id=0&sort=2a&page=1 When you go to page 2 you see no products.

[burt]

You are asking the SQL to find a category that is non existant, you appear to be using the osCsid ??

[Mazer]

If the value is 0 it does not include it in the search parameters, it was to determine if a value has been selected or not, This problem persists even with the osCsid gone. The query runs exaclty as expected and it returns only 19 results(No extra empty records etc). The output is just adding all these extra blank results.

 

The form "Shop Assistant" to the left is what generates this page after user input.

[Mazer]

This might be a better example:

 

http://www.jollysofttoys.co.uk/assistant_search_result.php?Age_Range%5B%5D=123&Age_Range%5B%5D=124&Toys_by_Price%5B%5D=30&manufacturers_id=0

 

7 results returned, page says 25.