scorecard page

what is the best way to create a scorecard page

[paizay]

hi,
I was wondering if anyone could help with the best way of creating a page which needs to be updated regularly with scores for a squash team with formula's to work out the scoring!

hope this is the correct forum - if not apologies & please advise :-)

thanx :-)

[jatar_k]

Welcome to WmW paizay

if you want formulas to calculates scores based on what you input it would sound like you might need a little bit o' scripting. I have a few questions.

1- is this a page to be added to an existing website?
2- how complex are the formulas you need to use?
3- do you know scripting etc?
4- what kind of server do you host on and what langs are available.

that should get us started.

[paizay]

Hi Jatar-K
Thanx for replying :-)
1) I am currently creating the site,
2) I need to add the scores together per match then add some bonus points depending on how many games won
3) I know some very basic javascript
4) The site is hosted on an Apache webserver

I was wondering whether to use a database to enter in the scores and then filter this out somehow into html ????

[jatar_k]

a db would probably be the best way and then use a language like php to pull them from the database and do your calculations and then spit them out.

Is it a mySQL db with PHP available from your host? I assume that is a *nix server.

[paizay]

Yep it's a L*nux server, they now offer sql (finally) so would i create the db then use sql to query, php for calculations & to populate the html??? Is php awkward to learn or can u pick it up easily (ish)?

[jatar_k]

i found some threads to get you started

php/mysql need pointer/advise to get started [webmasterworld.com]
php beginner [webmasterworld.com]

you can use the site search in the top menu to find more threads and also check in the Perl, PHP, and Python Scripting Forum [webmasterworld.com] to find and post more specific questions.

Other good resources are
[php.net...] and
[mysql.com...]

It isn't really that hard but it is not easy either, I find once you get your head around basics it comes along after that. There are a lot of knowledgable folk around here to help out too.

[paizay]

Thanks for your help, much appreciated :-) I will follow the links and see how I get on.

[jatar_k]

in the site search I put in "learning php" and came up with the above threads and a bunch of others.

good luck