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.............................

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

then brother how to go about it

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

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)
);

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

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.