mySql tabels linked on basis of one common cell

[lkrvk]

hi, guys i have a problem here.
i have a form which creates a new table for each new user and that user will have a monthly update of his salary now im confused how to go about this. do i need to create a new table or how to go about.............................

[smantscheff]

It's utterly nonsense to create a table for each new user.

[lkrvk]

then brother how to go about it

[lkrvk]

name:
email:
phone:
address:

this is the form for the new user and the below is for salary update for every month of each user

amount: date: check number:

this is the format i want brother please help me im struck up

[smantscheff]

Create one table for users, one table for salaries, and join them on the user ID.

create table users
( id integer not null primary key auto_increment
, name text
, email text
, phone text
, address text
);
create table salaries 
( id integer not null primary key auto_increment
, id_user integer not null
, year integer not null
, month integer not null
, salary float not null
, foreign key (id_user) references users (id)
);

[lkrvk]

thanks bro but i dint get the second part of it could u please detail it for me

[smantscheff]

What is the second part? And did you ever consult a manual?

[lkrvk]

CREATE TABLE salaries
( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT
, id_user INTEGER NOT NULL
, YEAR INTEGER NOT NULL
, MONTH INTEGER NOT NULL
, salary FLOAT NOT NULL
, FOREIGN key (id_user) REFERENCES users (id)
);

this part is a bit confusing whats the manual where is it i don no anything about it i am a newbie

[smantscheff]

This is a manual: http://dev.mysql.com/doc/refman/5.1/en/create-table.html