adding multiple values to a single field
Posted: Thu May 20, 2004 5:50 pm
hello, i´m new to this forums and somewhat amateur to php and i love it
but i have a problem.. serious problem. I have a database called db1, it is used to record users, their data and one of this data is a field used to store wich applicatiosn this user can run.
Let´s say John has the right to run Excel, Word and Access, and not the rest.
I have two tables, one is called User and the other table of the application list is in the table applist
What i´m thinking, is to have the field applright (for the application permissions) inside he Table Users. this field will have two fields, applid and applname.
I will have a form where i can choose form a multiple selection list all the applications the user can have the rights.
What i dont know is how to store this, because all the values form application tables will be stored in a single field, Users. can it be done? is there a better way to keep a record of so many values in a sigle field?
thanks
but i have a problem.. serious problem. I have a database called db1, it is used to record users, their data and one of this data is a field used to store wich applicatiosn this user can run.
Let´s say John has the right to run Excel, Word and Access, and not the rest.
I have two tables, one is called User and the other table of the application list is in the table applist
What i´m thinking, is to have the field applright (for the application permissions) inside he Table Users. this field will have two fields, applid and applname.
I will have a form where i can choose form a multiple selection list all the applications the user can have the rights.
What i dont know is how to store this, because all the values form application tables will be stored in a single field, Users. can it be done? is there a better way to keep a record of so many values in a sigle field?
thanks