I know that this, or very similar, questions have been asked and answered in the past but I cannot get this to work and would really like some help.
I have a login page and two tables in a MySQL DB.
Table 1 is a table of Contacts and
Table 2 is the Login table which just has contact_id, username and password.
The user enters username and password in the form fields and then submits
So there is the Database Connection, followed by Security Provider and Security Restrict. I then have a Database Query to join the two tables based on the contact_id. The results of this query are needed throughout the rest of the app. For instance…
How can I put these results into either session variables or cookies for use on other pages?
And can it be done at this point or should the query be run on the next page?
I have looked at Using Session Variables, Logged User Session Name, Getting Details of the Logged In User and Binding them to your page and others but I can’t see how to populate variables without having to populate a form. I am sure it is simple but I can’t see it. Cheers all.