Jump to content

Insert search result to another table


jpergega

Recommended Posts

Hi

I have a system that has two different types of users staff and student.

If I logged in as a staff I can search an existing students':(username, firstname and surname) then I want to copying the search result(a selected existing student account detail by click a button) into another database table.

Right now both users' details are store in one table called userAccount and there is a permission field in the table to distinguish the two.

My question is if I logged in as a staff and I want to copy a student's detail into another table in the mysql

What do I need to change and add in that new table then?

Many thanks

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...