Need To Create An Automatic Updating League Table!

[BAW]

Hi,

First the background information - I run a website for the FA, they have recently launched an Under 21's League. They want the Fixture & Results posted on the site, with a league table.

There is the problem, I need to league table to automatically update according to the results I put in.

I believe JavaScript is capable of this, I have spent the last few days learning a basic ~ intermediate level of JS. However, I am still stuck.

If you think you could help me out then reply here, I know this is one hell of a lot of coding so if you can only point me in the right direction that would be great!


A side note -- I was thinking about it and well the JS needs to pull information from another internal web page, which I believe it cannot do. However, I'm lead to believe it could read it from a file on the server? If so I guess I will need to create a form to submit the results?

Hope someone can help me out

Thanks,
Ben

[Philip M]

As you say, one hell of a lot of coding.

Have a look at
http://www.codingforums.com/showthread.php?t=160272
which may provide some tips.

Used with an AJAX call Javascript can read from a file on the server.

You should really go for a server-side solution with a database.

But if this is a website for the FA you ought to pay a professional to do the job. "A few days" study of Javascript is not at all adequate.


"Success is the ability to go from one failure to another with no loss of enthusiasm." - Sir Winston Churchill, British politician (1874 - 1965)

[BAW]

Originally Posted by Philip M

As you say, one hell of a lot of coding.

Have a look at
http://www.codingforums.com/showthread.php?t=160272
which may provide some tips.

Used with an AJAX call Javascript can read from a file on the server.

You should really go for a server-side solution with a database.

But if this is a website for the FA you ought to pay a professional to do the job. "A few days" study of Javascript is not at all adequate.


"Success is the ability to go from one failure to another with no loss of enthusiasm." - Sir Winston Churchill, British politician (1874 - 1965)

Hey Philip,

Unfortunately that is not what I am looking for
I know that a few days of JS study is nothing, tbh I have learnt a lot but that is only the bare-bone basics of the language!!

It is for the FA yes. However, as it is more of a local FA website they are not willing to put much money into it, hence the reason a 16 year old "computer wiz" (NOT) has been asked to make it! And not a pro! Don't get me wrong I love doing it, great thing to practise!

I can type it all into a table manually for the time being as there are only a few teams but the league is expected to expand next year 2 or 3 times so I need to be prepared!!

I use a CMS called E107, and have looked up and down for a plug-in, literally 10mins ago I found a potential plug-in I could use but the author of the plug-in has not finished it and I don't think he is willing to release it so that's annoying!!

[Old Pedant]

There is an only mildly hacky way you can do this.

If you have Excel (or maybe a freebie equivalent), you could enter the info into a spreadsheet, on your computer. Or, of course, let somebody else do the work of entering results each week. Most people who are marginally computer literate can handle entering data into Excel.

Then you EXPORT the Excel data as a "CSV" file (Comma Separated Variables), which is an ordinary text file. Upload that to the site, and then your JS code could, indeed, read that text file and parse it, in order to show results in a web-bish way.

A CSV file will come out looking something like this:

"Team","Opponent","MatchDate","ScoreFor","ScoreAgainst"
"xyz","abc","6/11/2010","3","1"
... etc. ...

And that *can* be parsed by JS coding.

But it would be even easier if you are able to specify that the DELIMITERS used are *NOT* commas and that quote marks are NOT put around each value.

Instead, ask that the delimiters be TABs. And then parsing the text file in JS is nearly trivial.