Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatically update tables

    Hi Guys,

    Apologies for my ignorance, but I'm hoping someone can point me in the right direction. I run a football league website which is hosted on the webs.com platform. Although it is easy to use, I can't see any 'advanced' features for doing what I want to do.

    Currently after a round of fixtures I have to update the results and scorers on one page, head over the league table page and then manually add rows to move teams up / down the table and add up points, goals scored and goals conceded etc. Then finally, over to another page to update the top scorers and best goalkeepers, again by adding in a row, adding up their new total and slotting them into the table (and all this 3 times as we have 3 divisions!)

    Now in my head I should be able to choose the score from a drop down box and then select the scorers from a pre-set database of names attached to teams. Once I hit confirm, that will automatically populate the league table with correct points, goals scored etc and then also update the top scorer and best goalkeeper tables as well.

    Does that make sense and if so, is it possible to setup!?

    Phil

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,947
    Thanks
    79
    Thanked 4,424 Times in 4,389 Posts
    Very possible. But it--and the display of the results to all your users/team members--will need to be done with some kind of server-side coding: PHP, NodeJS, ASP.NET, etc.

    And you will also need to learn the SQL dialect appropriate to the database you use (for the most part, SQL is universal, but there are decided quirks in each DB--SQL Server, MySQL, etc.).
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #3
    New to the CF scene
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That sounds like fun! Is it something that would be easily built by someone who knew what they were doing? (i.e not me!)

  • #4
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,502
    Thanks
    8
    Thanked 1,089 Times in 1,080 Posts
    I'm going to guess with that free web service, they don't allow server-side scripting, let alone a database.

    Email or call them and ask what they allow ... javascript only? ... that's my guess.

    Subscribe to a REAL webhost account for $40-$60 per year ... and that includes your own domain name. Of course, you still need to hire a programmer. But then it can be done.
    Last edited by mlseim; 07-29-2014 at 04:35 AM.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •