I currently have a MySQL databse with two tables, memebers and memberinfo.
I am using the members table for the user sessions and login, the table is as below:
|| ID || USERNAME || PASSWORD || SALT ||
I then have another table with..
|| ID || USERNAME || FirstName || Phone || Ect..
I will be adding lots of random coulmns to the second table and I dont want all of that data to be in the original members table so that it is kept puerly for logging the users in/out.
That being said, I want the tables to link, so that every time a new user is added via the php form, ID and Username are added to the member info table too.
Is this possible just in MySQL or will I have to tweak the PHP.
Thanks