Hi
Could somebody please help a novice PHP Runner user in establishing the correct start of a database I wish to build. Initially I would like the database to have three tables, one which would be assigned to the login process, a second table would include additional information about the logged in user, and a third table for any viewer to add comments (I don't want the viewers to have to log in to be able to add comments, although they will need to submit an email address).
the three tables would have the following fields
login table:- name, surname, email, username, password (username has to be unique, so I wondered if this would be assigned the primary key)
information table:- age, gender, hobbies, location
comments table:- name, surname, email, comment
The login table is used for registering a new user
The information table can be viewed by anybody (no login required, but can only be added or amended by the said logged in user)
A viewer (not logged in) can search and look through all the records in the information table, when they wish they can add a comment to a particular record which will then be displayed with that record in the information table.
First of all is this possible and secondly, could somebody please set me in the right direction of initially setting out the correct relationships for these tables.
Many thanks
Paul