[CutAndPaste]

I'm a complete newbie to editing PHP so don't take anything for granted...

I'm currently using DaDaBik as a front end to a MySql database on my Running Club Website to display Results of a Monthly Time Trial Race
This works fine as a way of getting basic data entry and reporting.

However, what I'm wanting to do (and can't do from within DaDaBik) is to create another page that lists the fastest time for each Runner (sorted fastest to slowest) so that we can show a listing of each person's fastest times. DaDaBik allows me to show all the sorted times, but if a Runner has say two faster times than the next fastest, they get listed twice before the next runer.

To further complicate matters, ideally I'd like to seperate the runners into male and female!

Tables:
Table_Runners
RunnerID (as PK)
RunnerName
RunnerGender

Table_Events
EventID (asPK)
EventName
EventDate

Table_Times
TimeID (as PK)
Runners_RunnerID (as FK)
Events_EventID (as FK)
RunTime

Can anyone point me in the right direction. I've done some MS Access query design but this is all new territory!

Many thanks,
Simon