Some advice on databases - please!

[ruinedli]

I've been tasked with setting up a website for a fantasy football competition. I know that one of the tools on siteground will help me, I'm just not sure which to use!

The basic premise is that there are approx 200 Team managers. Each gets to select 12 teams/players to form their overall squad from approx 140 teams/players that are available. Each week, as games are played, points are given to each of the 140 teams/players - Team Managers are then positioned in the league according to the points their selection earns.

From a user point of view I want a website where they can run queries on things like overall league standings, their teams points that week/total, top 10 teams, top 10 players etc. The website is purely for Team Managers to look up this information.

Can I do this through PHPMyAdmin by setting up tables? Or do I need to go for a full content management system like PHP Nuke or Xoops? If so, can anyone recommend one?

Whilst I have experience on html/CSS side, I've not touched anything like this before so simplicity would be good.

Any suggestions very gratefully received!

Andrea.

[miguel]

In order to implement the system that you are describing you definitely need some prior knowledge in database structure, SQL, and some programming experience in a scripting language like PHP or Perl. Even if you decide to use phpNuke or other CMS, you would still need to implement the scripts that do your queries to that managers/players database yourself. phpMyAdmin is a fairly good and useful DB management tool, provided that you know exactly what you are doing.

I would suggest that you seek some experienced help here if you are unable to do it yourself or if you lack the time to learn the required skills. If you do not have a person to turn to, you can seek our help. However, we cannot guarantee any timeframe.

Good luck!

[ruinedli]

Cheers Miguel. I was worried that someone would say somthing like that - looks like I have a seriously steep learning curve ahead of me :eek:

Thanks for your help!

Andrea.

[neednam]

a member on my site is currently developing the samething for this up coming football season. He is about 90% done. Maybe if you ask him nice enough he may share his source and sql creation queries.

go here (http://www.need-name.com/mboard/), register and look for bigheadtodd.

_scott

[Tom]

A friend of mine was developing such software too. However, he did use an open source application, and he just wrote some additional code to it, to suit his needs.

I know that for sure, because I did have a team on his webpage, and I did win some games too :)

I have lost touch with my friend, so I will not be able to ask him what this software name was. However, I will do some research on my own and get back here when I find something:)

[ruinedli]

Thanks for all the help. I've installed Mambo & think I will find my way round that first before tackling the php. Having young kids & working tends to limit time to learn to about 2 mins per day ;)

Besides, am quite hopeful that I can find a Mambo component to install that does at least half the job.

However, thanks Scott for the kind offer of approaching your friend, I'll keep that in mind when I hit a brick wall!

Thanks again for your help.

Andrea.

[nxedit]

Here is something that is potentially a good fit and the best thing is, the hard work is already done for you.

Install PHPWebsite, one of the CMS options in Fantastico
There is a 3rd party module for this CMS called "leaguesite" that offers a very decent solution for a sports website.

To read what this can do, go to http://www.phpwebsitemanual.com/ and click on the "leagusite" link in the 3rd party mods box on the left. It provides screenshots and a sample site. I think you will be impressed.

I was and I am currently using it to build a Lacrosse website for my son's team. So far I am delighted and there is NO WAY I could have built that myself.

While I am using it for Lacrosse, it is pretty generic and should be fine for your needs.
Good luck

[ruinedli]

Thanks - I've taken a quick look and also gone to the forums to get an idea of adaptability - it certainly looks like something I could play with. I'll take a closer look when I have more time, but thanks ever so much for the pointer.

It's starting to look hopeful now ;)