Em Andamento

Search and display

I manage a website for some friends who organise a running race.

I have a searchable results page at <[url removed, login to view]>

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:

<[url removed, login to view]>

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.

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: search for people, people search work, people search find, pair line, new first search, Summit, php sql syntax error, database results error, sql syntax error, search next, php code find friends website, mysql sql syntax, sql server linked server, sql running 100 time, sql syntax, sql work together, adding searchable database website, mysql hyperlink, sorted note, 100 website next year, tweak project, search options php mysql, php project course management, searchable database files, search results page mysql php

Acerca do Empregador:
( 93 comentários ) Australia

ID do Projeto: #3037637

Premiar a:

wagzlu

See private message.

$55.25 USD em 14 dias
(64 Avaliações)
5.7

6 freelancers estão ofertando em média $38 para este trabalho

codez4future

See private message.

$51 USD in 14 dias
(94 Comentários)
5.6
elan619xi

See private message.

$42.5 USD in 14 dias
(117 Comentários)
5.3
rudydelhi

See private message.

$42.5 USD in 14 dias
(52 Comentários)
5.1
movingtoweb

See private message.

$15.3 USD in 14 dias
(36 Comentários)
3.6
emailsolutionvw

See private message.

$21.25 USD in 14 dias
(10 Comentários)
2.6