|
|
Posted by smk17 on 09/19/06 12:32
Thanks, after looking into this a little further I think the Excel idea
is gone. I think all I need to do is give each one of these volunteers
a password protected web page to go to and fill out a form with the
score of the game. That form somehow updates a database and that
updated database updates the actual "Scores" page on the basketball
website.
Now I just gotta figure out how to make all those connections.
My web host does support MySQL and PHP.
Jerry Stuckle wrote:
> smk17 wrote:
> > I apologoze for not giving a good subject line, but I have no idea what
> > to even ask for...
> >
> >
> > I've made a website about high school basketball in New York State. One
> >
> > thing I want to put on the site are the scores from each of the games
> > and I'd like to somehow get the scores up ASAP. There are many games
> > basically every night of the week. With around 70 teams in my
> > particular section. One way to do it would be to "hire" a
> > representative from each school (a player, coach, fan, parent, etc.) to
> >
> > volunteer to send me the scores from his/her game through email. This
> > might work but it would require a lot of work on my part reading each
> > email and posting the scores manually. Or I could look at all the
> > online newspapers and post those scores to my site. But I want the
> > scores up even quicker than that. And I'm sure there would be times
> > where I wouldn't find articles on all the games. Yes, I may be crazy.
> >
> > So I thought maybe there would be a way where this volunteer could go
> > to a password protected web page, fill out a form or something that is
> > specific to his/her school, with the score, date, teams, etc. and that
> > would automatically update that section of my website that has all the
> > scores on it. I wouldn't have to do anything.... :-)
> >
> > Or maybe they send me an Excel sheet after every game and my scores
> > page is "hooked" to that excel sheet and just by updating the Excel
> > sheet to the server, the scores in the web page are updated. I know a
> > guy from another section does it this way, but he has one Excel sheet
> > with all the scores from it. This excel sheet comes from a guy who runs
> >
> > a clearing house at his home where all the coaches call him after their
> >
> > games. They leave their message on the machine, he listens to the
> > message, and he puts all the scores into this one excel sheet, sends it
> >
> > to the webmaster from that section, and vwalla, the scores are there.
> > He said it was all done with javascript or php, maybe both.
> >
> > section4hoops.com
> >
> > I am not familiar with writing javascript or php, but have downloaded
> > many scripts and used them correctly.What I do not know is how the
> > connection is made between the Excel sheet and my webpage.
> >
> > Can anyone point me in the right direction or maybe you have another
> > solution I hadn't thought about.
> >
> > Thanks
> > Steve
> >
>
> Steve,
>
> Either having a page requiring login or parsing scores from an Excel
> file is going to take a little server side programming. Neither would
> be too hard, depending on what other things you have available (i.e.
> database, etc.). But if you're not familiar with PHP you're going to
> have a little trouble with it.
>
> Maybe you can find someone locally who is familiar with a server side
> language such as PHP or Perl. Either one should be able to do what you
> wish.
>
> And unfortunately, I don't know of any prepackaged scripts for something
> like this. Both are simple enough I normally just write them to suit
> the site.
>
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================
Navigation:
[Reply to this message]
|