I manage a website for some friends who organise a running race.
I have a searchable results page at <[login to view URL]>
It works well if none of the options are specified, but once you select a year or gender, course, etc, an error is displayed like the one below:
Error retrieving results from database!
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND course='summit'' at line 1
I can give you the code for the pages. I just need this tweaked.
The other thing I'd like is to have an option for people to choose to have either 10, 25, 50 or 100 results displayed on a page and perhaps also all results displayed on the one page. This would need to be accompanied by four linked buttons like this:
<<? ? ? <? ? ? ? ? ? ? >? ? ? ? ? >>
...for first page, previous page, next page and last page, respectively.
## Deliverables
Please note:
This version in some ways works better than the hyperlink above:
<[login to view URL]>
HOWEVER, when I add new results to the database, they are currently listed below all other results, and not sorted in time order.
So if you go to this link and select search without adding any criteria, you will see "Jo Blake" as the bottom result. He was first in this year's race, with a race record time, and should therefore be the first result.
I have included 4 files. They work together as two pairs. Tweak whichever pair you find easiest to work with.
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]