Okay, I used a tutorial from nettuts to create a log in form, so that's done.
However, I would now like to create a form to update a scoreboard powered by a database (unless there is another method that may be more efficient.
I have four teams and thus four scoreboards that I will write over each week.
i.e., one board will also have the score of the latest game for the same team. Another board for another team, etc.
I have a table set up with six rows. ID, Away, Ascore, Home, Hscore, status
INT is the primary key and is set to auto increment.
Away is a varchar 40 chars
Ascore is a three digit int
Home is a 40 varchar
Hscore is a three digit int
status is a 40 varchar...will either have "Final" or the date of the upcoming game.
The only thing is, I have no idea how to go about this.
Maybe the best/easier would be to have four forms on the page...have one set up to call game id 1, another for id 2, etc. Then have the field information there and update.
The reason I am doing this is because I want to be able to update the form from my blackberry...it's for a new football website so I would need to update it from the sidelines.
We are not doing live scoring with this, just final scores. But we have score reporters are different games so I need to be able to update as those reports come in as I stand field side at another game.