Thread

Hello, first off I’m sorry if this question has been asked already. I just don’t have enough time to search that thoroughly for an answer. I’m wondering if its possible to create a table in EE and have the client edit it easily though some type of WYSIWYG. What I’m looking to do is create a table to handle stats for a team. Of course I want the client to be able to edit these stats all by themselves fairly easily since they don’t have any web coding experience.

Is this easy to do? Or would I be better served to create a php form for the client to use that would submit the form to a mySQL database?

There’s always time to do a quick search… 😊

It would depend on whether you want calculated stats, or stats that they would just be updating.
If you’re just updating existing stats (ie, not calculating out something like win/loss %, record, etc), then you can just have one weblog entry for the stats you’re changing.

For calculated stats, I’d do something a bit more like the following:
I’d set up a weblog where I’d have one entry per result. One entry for a game/match/etc. If you wanted to have calculated stats (like a summary or something), you’d probably need to do some php magic to calculate the values of multiple weblog entries.

For more advanced per player stats, you’re probably looking at doing a massive amount of entered data. For a swim meet, I’d have 1000+ lines of stats to import, and I don’t know where I’d begin in those instances. I’d probably make a module to handle it all or something.

I know there’s a few people around here who have done sports teams sites, and I’d be interested to hear how they set things up too.

Awesome.. thanks for the help! I just tried the weblog method and it works perfectly!

Glad that helped you out. Are you doing just one weblog with custom fields and one entry that you edit? Or are you submitting multiple entries and showing a “table” of results (multiple entries)?

I created a weblog with custom fields. Then I just pumped those entries into a table 😊 It works PERFECT! Thanks for the help.. I really appreciate it.