Simple PHP system help

[emkay]

I'm currently working on a client login/management script for my A2 coursework and I've come across a small dilemma. The clients in the system will be have multiple projects (instead of just one), what's the best way to implement a way to allow them to choose the active project? Do you think it would make more sense to have some sort of dropdown on each page or something else?

[sneakyimp]

You could ask them when they login 'which project' on a form. When they choose a project, you could store it's id in $_SESSION.

[Ashley_Sheridan]

In your database, use one table to list your projects, and another to list your users.

If a user can only be linked to one project at a time, then their login will determine what project they have access to. If they can be linked to several projects, then you can show this in your database structure:

One table lists the projects, another table lists the users, and finally a third table links user id's against project id's.

When a user logs in, then show them a list of the projects they have access to and let them choose. A fairly simple join can be used to link in the 3 tables together.