I'm a newbie and would appreciate some guidance.
I created a user registration form and a login form.
The user information from the registration form includes a user name and password, among other fields. The user name and password fields, only, are entered by the user into the login form when initiating a session. The information that the user provides in the registration form is stored in a customer information table through an insert query. As currently coded, the user is able to login with the code retrieving and validating the user name and password from the registration table. However, an additional step that I would like to take is to not just have a successful login but to store each login session with the date and time in a separate login table. I already have an auto-incremented customer id field as the primary key in both the registration and login tables that I created. No matter how I code it, I can't get the login session with the user name and time to get entered into the login table. Can someone help me understand how to program this process and where to insert the code? Thanks