Ok, so here is the situation....
We use filemaker pro to run a set of databases to manage the timing for a mountain bike race. One database contains a list of rider and another contains a record for each lap that is completed. These laps are then sorted in various ways to compile results in a pdf form. These pdfs are then hosted on a local intranet at the race so people can use their wifi devices to look up the results. The problem is that these pdfs then have to be updated manually and transferred to a separate computer to host the intranet website which only gets done about every hour or so. People want live results (or semi-live) and I can't think of a way to do this. Users can't access the databases directly as this would cripple the network (there are like 10,000 records). I am thinking exporting new results at regular intervals to an SQL database and then hosting that on the intranet via a php website of some sort. However my knowledge of SQL and PHP are very limited... any suggestions would be kindly appreciated.
We use filemaker pro to run a set of databases to manage the timing for a mountain bike race. One database contains a list of rider and another contains a record for each lap that is completed. These laps are then sorted in various ways to compile results in a pdf form. These pdfs are then hosted on a local intranet at the race so people can use their wifi devices to look up the results. The problem is that these pdfs then have to be updated manually and transferred to a separate computer to host the intranet website which only gets done about every hour or so. People want live results (or semi-live) and I can't think of a way to do this. Users can't access the databases directly as this would cripple the network (there are like 10,000 records). I am thinking exporting new results at regular intervals to an SQL database and then hosting that on the intranet via a php website of some sort. However my knowledge of SQL and PHP are very limited... any suggestions would be kindly appreciated.