JeevesBond — Sat, 03 Sep 2005 12:53:17 +0000

jp0509 wrote: Sorry for all the questions and may seem ignorent

Don't worry about it, that's what we're here for! I've taken a while to reply to your post, so apologies for that

Have (finally!) managed to find a reasonable PHHP/MySQL tutorial, if this doesn't help then there are plenty of others around if you do a bit of searching: http://codewalkers.com/tutorials.php?show=9

Also invaluable references are:
PHP Web Site and
MySQL Documentation

In addition to that tutorial, you'll need to know a bit about:

Sessions and here's an easier tutorial
User Authentication Sorry to point you to a Sitepoint page, we don't like them generally Also I've skipped to the bit that's pertinent: User auth with sessions.
Database design - extracted from a book, but has some nice info in there.

You're correct, I can't just tell you everything you need to know, what you're embarking upon isn't an easy task and will take some time commitment!

jp0509 wrote: ince I want the points added up from stats from the main football site (not sure we are allowed to say other site names, but highly popular football site)..Can I filter in those stats into my site or is that something I will have to do manually?

Heh, depends upon the policy the site has, and whether they provide any easy/standard way of getting the results dynamically (also think about whether they're likely to change anything in their feed which could break your site before hacking around in their code, hence the need for a standards based way of getting the results). The best way to exchange this data is an XML Application of some description, there's no way of knowing whether they do produce this or would allow you to use it without looking and asking.

Hope this helps, and sorry I didn't reply sooner!

jp0509 — Tue, 30 Aug 2005 23:32:15 +0000

JeevesBond wrote: Ok, thanks for that! The next questions are:

What server side scripting language(s) does your host support?
What RDBMS does your host support (e.g. MySQL, Microsoft SQL Server, Postgre etc)?

Preferably go for PHP (I can see you've learnt a little of this - that's good) and MySQL - it's the killer combination of the moment

The simple answer to your question is: "Yes." It just depends on how much you're willing to learn, this is going to get quite involved!

Out of interest have you drawn up any requirements for this new site? This could just be a quick list of what a user of the site will be able to do, no need to do anything too complex. This will give you the start of a roadmap, not only that, you'll be able to derive what you need to learn in order to develop the site.

Wow, ok....

I am willing to learn whatever it takes to get it done. Just the kind of person I am. Whatever the easiest way to learn. I imagine it's not here...That would be alot of board space

As far as what my host offers, they offer PHP & MySQL (godaddy.com).

For the requirements, I hav not really thought about it yet since I was not sure if what I wanted could be done.

I guess what I invision is having a user create teams with players, and each week the system will add up the points for each player.

Now my question would be is this....Since I want the points added up from stats from the main football site (not sure we are allowed to say other site names, but highly popular football site)..Can I filter in those stats into my site or is that something I will have to do manually?

Sorry for all the questions and may seem ignorent, I have just not fooled with this part of designing yet. I have taught myself everything I know so far...well not myself, help of friends....I meant did not need school.. LOL

Thanks so much.
Jj

JeevesBond — Tue, 30 Aug 2005 22:46:55 +0000

Ok, thanks for that! The next questions are:

What server side scripting language(s) does your host support?
What RDBMS does your host support (e.g. MySQL, Microsoft SQL Server, Postgre etc)?

Preferably go for PHP (I can see you've learnt a little of this - that's good) and MySQL - it's the killer combination of the moment

The simple answer to your question is: "Yes." It just depends on how much you're willing to learn, this is going to get quite involved!

Out of interest have you drawn up any requirements for this new site? This could just be a quick list of what a user of the site will be able to do, no need to do anything too complex. This will give you the start of a roadmap, not only that, you'll be able to derive what you need to learn in order to develop the site.

jp0509 — Tue, 30 Aug 2005 22:08:33 +0000

JeevesBond wrote: So how is it working at the moment? Are you using any kind of server-side scripting or editing everything with HTML? If you are using server-side scripting what language and what RDBMS?

We know where you're going with this but need to clarify what you've got already and also what skill level you're at.

Welcome to the forums btw

Sorry, I am doing everything (stats) by hand and just entering them in using simple html. I just wanted to see if I could have it automated.

I'm not really good on this kind of designing, so I don't know what I would be getting myself into let alone, what I would need to try.

Skill Level - I guess Newbie (I know Javascripting, some PHP and of course HTML)...

JeevesBond — Tue, 30 Aug 2005 11:54:08 +0000

So how is it working at the moment? Are you using any kind of server-side scripting or editing everything with HTML? If you are using server-side scripting what language and what RDBMS?

We know where you're going with this but need to clarify what you've got already and also what skill level you're at.

Welcome to the forums btw