4 replies to this topic

[Tarquin]

Hi, me again,

As you may remember, I am developing a website for football(soccer) fans who travel away with their teams in the UK.

There are 92 English league grounds and there are a few fans who each year decide they want to try and visit each ground, and then there are the fans who over the years have followed their club to grounds all over the country and have lost count of how many or what grounds they have visited.

So, with this website that is under development, I plan to have a user system where fans around the country can sign up to the website, have their own username and password, their own profile and they can select radio buttons which would be next to the team names to show which grounds they have visited, then when they submit that, it would go into their profile that they have visited 'x number of grounds', then you could click that and it would show which grounds they have been to.

'Why are you telling us this?'

Im telling you this because I have no understanding of how I would be able to do this, im barely capable of creating this website, , what coding do I need to know for this? How easy would it be to create a system like this from scratch?

[Hayden]

there are superb tutorials all throughout this site pertaining to user systems.

http://www.pixel2life.com/tutorials/php_co...ership_scripts/

and

http://www.pixel2life.com/forums/PHP Tutorials

Edited by SpatialVisionary, 27 August 2006 - 08:14 AM.

[FelipeCtrz]

Well, user systems are not hard if you know something about PHP.

Read some tutorials and you will learn.

[Mr. Matt]

well a way of doing it, is having 3 tables, Members, Ground, Visited. The member table are Ground table are self explanitory (list of members and list of each ground).

And in the visited table, lets say user 10 has visited ground 34, you would enter a new row with the id's of the user and ground.

Nice and simple

Matt

[austen]

deadly, on Aug 27 2006, 04:08 PM, said:

well a way of doing it, is having 3 tables, Members, Ground, Visited. The member table are Ground table are self explanitory (list of members and list of each ground).

And in the visited table, lets say user 10 has visited ground 34, you would enter a new row with the id's of the user and ground.

Nice and simple

Matt

exactly.

The way I learned is from a book actually... the owner of phpfreaks.com has a book out called creating interactive websites with php and his name is eric rosebrock.... it's a VERY good book, I highly recommend it!

-austen