Hello Guys,

 

This is my first post.

 

Right, Im using wordpress for my articles and pages but the main site is mainly a cms.

 

I want to add statistics to the website like other football websites. ( i also have no experience in databases)

 

like this for example

http://www.arsenal.com/first-team/players/cesc-fabregas

 

 

my current website is www.longbentonfc.co.uk

 

thanks

 

andy

The Arsenal site would have been custom built from the ground up, and that would have cost them a small fortune.

 

You could do something similar using a CMS, Drupal, Expressionengine or perhaps ModX spring to mind as they have all the necessary functions such as data relationsips in place.

i currently use wordpress...

 

is it possible to use excel as a flat file database?

You can't use Excel but it's possible to use an Access database, but you'll need a windows server.

 

Perhaps if you went into detail a bit nore it will help people to find a solution for you?

 

What sort of stats do you want to display?

How would you like to update them?

Can each player be associated with a team?

Do you want to store things like goals scored, matches played etc?

Would help but you seem to be an arsenal fan..

Only joking.. but I am not very good on this side of things..

 

But couldn't you use PHP and mySql? Have a database with player name then dob/position etc.. And then on the pages get the data from the database for the specific player?

 

And if it needs editing/updating have a page on your website that only admins can access with forms to update?

 

P.S.. I feel dirty that I opened an Arsenal page

Haha... sorry no im a Geordie and a Newcastle Fan. Its just the Arsenal website is different from most football sites as they are normally all premiumtv sites and arsenal isnt.

 

i currently have stats on a excel spreadsheet recording various stats

 

eg

 

name pos played goals conceeded yellow red mom awaymom

 

jblogs gk 1 0 1 0 0 0 1

sumone fw 1 1 1 1 0 1 0

 

do you see what i mean.

 

and i would like to have a database (im no good at access) so i can simply just update the database/spreadsheet and it will automatically update the players profile.

 

and then have a seperate page to record all the info as a table.

 

is that enough info or do you get an idea of what i mean?

its highly possible and pretty straight forward (using php & mysql)

 

have a web form which only an admin can use

 

it grab data from the database such as the player name, games played etc etc

 

you can then update the numbers / players names / delete a player, add a player etc

 

its quite simple if you know php,

 

you will then have a page for people to view which will grab the data from the database and display it in a nice format for them to view

 

www.w3schools.com/php will cover most of the basics to building it

ok ill have a look.

 

im no good at php/mysql .... i know html and css...